| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macros Disabled
Steven,
I'm glad I could help. Doug "Steven" wrote in message ... Thank you for all your responses. After review and testing I will say Doug has the solution. If you only do this on the before_close event then the system will ask the user if they want to save again, because in fact there has been a change, and at that time the file will be only showing the one sheet that has the message on it, which is something I dont want the user to really clue in on anyway. Therefore the before_close will not work. And you cannot do the hide alone on the Before_Save because the user may be staying in the file to continue working. Therefore you have to do in in the Before_Save ... Save the file ... Switch it back to the users normal view ... then Cancel the Save, and all is well. This keeps things working in the users normal course of operation of the file which means doing what Doug recommends is the best way I believe. Thank you very much. This issue has really bothered me for years. Like about 20 years. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macros disabled | Excel Programming | |||
| Macros disabled | Excel Programming | |||
| Disabled Macros | Excel Programming | |||
| Disabled Macros | Excel Programming | |||
| macros disabled | Excel Programming | |||
Hybrid Mode
