| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable File-Save menu item in macro?
Thanks. I use the ActiveWorkbook.SaveAs method to save the file to the
server and discovered that the BeforeSave event is triggered by this method. Is temporarily disabling events using the Application.EnableEvent property the best way of dealing with this? *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Disable File-Save menu item in macro?
Yes.
In article , BrianG wrote: Thanks. I use the ActiveWorkbook.SaveAs method to save the file to the server and discovered that the BeforeSave event is triggered by this method. Is temporarily disabling events using the Application.EnableEvent property the best way of dealing with this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| menu / toobar item for open file by name | Excel Discussion (Misc queries) | |||
| Control item PRINT in menu FILE of Excel | Excel Discussion (Misc queries) | |||
| in a excel file, how to make a menu item for the .xls file that when clicked on it runs myform.show? example plz | Excel Worksheet Functions | |||
| Macro to display a menu item - possible? | Excel Programming | |||
| macro to disable the printpreview menu | Excel Programming | |||
![BrianG[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
