Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Goal:
I'd like to display some basic information when a company intranet user opens a macro-enabled workbook. The information can be in text form, not more than a paragraph.

Problem:
The workbook is .xlsm with macros, so macro functionality is off by default for most users. The macros can stay disabled until the user wants to take advantage of advanced features. But the information must show up when the workbook is opened, without interfering with the data in the workbook.

Solutions to avoid:

  1. readme.txt with the file
  2. a seperate worksheet
  3. putting the information within cells in the spreadsheet, even in a header row

Ideas?

share|improve this question
    
What have you tried so far? –  CharlieRB Aug 23 '13 at 15:28
    
Within my office, I've used a startup macro. Coworkers are saving the sheet in a folder that has been authorized in the trust center to allow macros. Now that it's accessible to almost anyone, this is no longer an option. –  Aaron Thomas Aug 23 '13 at 15:43

2 Answers 2

up vote 0 down vote accepted

Insert a comment in a cell, then "show comments" and save the workbook? Probably not as pretty as you'd like; but you could argue that it avoids putting information in a cell.

share|improve this answer
    
This is probably the answer that meets all requirements. Like you said, not pretty but it works. –  Aaron Thomas Aug 29 '13 at 15:20

The solution that meets all requirements is to insert a comment in a cell.

However, I ended up breaking one of my requirements by inserting a spreadsheet in that says "Please turn on macros." I turned off the sheet tab visibility saved with this info sheet active, so when someone opens up this workbook that's all they see. Once macros are turned on, all the other features are unlocked and the workbook automatically navigates away from the info sheet. This seemed to be the best way to provide direction for the unknown people who will be using the workbook.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.