| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can I make an Auto_open macro conditional?
Hi David,
Can I do it? ie, make the autoopen conditional on the copy being read only? If ThisWorkbook.ReadOnly=True Then Exit sub Regards, Jan Karel Pieterse Excel MVP http://www.jkp-ads.com Member of: Professional Office Developer Association www.proofficedev.com |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can I make an Auto_open macro conditional?
Hi Jan
So simple when you know how. Very many thanks. David "Jan Karel Pieterse" wrote: Hi David, Can I do it? ie, make the autoopen conditional on the copy being read only? If ThisWorkbook.ReadOnly=True Then Exit sub Regards, Jan Karel Pieterse Excel MVP http://www.jkp-ads.com Member of: Professional Office Developer Association www.proofficedev.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i change or make this macro??? pictures and code included | Charts and Charting in Excel | |||
| Macro to Combine 2 columns to make one column without merging | Excel Discussion (Misc queries) | |||
| How do I set a date range for conditional formatting in a macro? | Excel Worksheet Functions | |||
| Conditional Macro | Excel Worksheet Functions | |||
| make a conditional format the default | Excel Discussion (Misc queries) | |||
Linear Mode
