Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
identify 'save as' of the commandbar 'worksheet menu bar'
Hey,
in case of saving a worksheet the user should get a message "Do you want to change the original spreadsheet ?". But this advice should not raise when the user wants to 'save as'. Using the beforeSave-Event will capture both of the above actions. But how to distinguish the actions 'save' and 'save as' ? Thanks for your hints Manfred |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
identify 'save as' of the commandbar 'worksheet menu bar'
Hi Manfred;
Excell normally detects if changes have been made but in some cases especailly if changes have been made using VBA code it will not. You can control wether the user gets prompted by using this line in you code. ActiveWorkbook.Saved = False If you set it to false they will get prompted no matter what and if you set it to true then they will not. Hope it helps, Greg -----Original Message----- Hey, in case of saving a worksheet the user should get a message "Do you want to change the original spreadsheet ?". But this advice should not raise when the user wants to 'save as'. Using the beforeSave-Event will capture both of the above actions. But how to distinguish the actions 'save' and 'save as' ? Thanks for your hints Manfred . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
identify 'save as' of the commandbar 'worksheet menu bar'
The SaveAsUI parameter of the WorkbookBeforeSave event passes True if the
Save As dialog will be displayed. See Help. -- Jim Rech Excel MVP "Manfred" wrote in message ... | Hey, | | in case of saving a worksheet the user should get a | message "Do you want to change the original | spreadsheet ?". But this advice should not raise when the | user wants to 'save as'. | | Using the beforeSave-Event will capture both of the above | actions. But how to distinguish the actions 'save' | and 'save as' ? | | Thanks for your hints | Manfred |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Identify the windows just below the menu | Excel Worksheet Functions | |||
SAVE and SAVE AS options disappeared from the drop down FILE menu | Excel Discussion (Misc queries) | |||
How to identify active Menu Bars | Excel Discussion (Misc queries) | |||
Save & Save As features in file menu of Excel | Excel Discussion (Misc queries) | |||
Add control to the Chart menu of "Chart Menu Bar" commandbar | Excel Programming |