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?
|