View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
David M Hargrave David M Hargrave is offline
external usenet poster
 
Posts: 1
Default Can I make an Auto_open macro conditional?

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?