Can I make an Auto_open macro conditional?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm a Finance Manager who's written a spreadsheet for users to access latest
list of our nominal, costing and purchase codes. It's got an auto_open macro
which refreshes each list before use. Users save it after each use, so it's
virtually always completely up to date.

But I'd like to "stop" the auto-open macro for second and subsequent
concurrent openings (which are read-only), just to save users time.

Can I do it? ie, make the autoopen conditional on the copy being read only?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto_Open Macro 2
Macro To Run Automatically For Any Worksheet Upon Opening Of THe F 2
Run Macro Automatically When Excel 2003 Opens 2
Macro to jump to today's date 9
trying to replace auto_open with something like workbook_open 1
Clear a cell's contents when document is saved 2
Remove/suppress Auto_Open macro 3
Macro Fill Cells With Formula; Conditional To Seperate Column 3

Back
Top