| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Disable "Save As" Option
Is there anyway of disabling the File/ Save As option from the toolbar in
Excel. I want to force the user to use a CommandButton save macro in the form I have developed. Thanks -- Andy T |
|
#2
|
|||
|
|||
|
Hi Andy
It's a little dangerous, given that the user may have multiple open files and your code may err while restoring the functionality. However, your workbook has a Before_Save event in the ThisWorkbook module that will give you total control of the saving process. Like, set Cancel to true there and call your own macro. HTH. Best wishes Harald "Andy T" skrev i melding ... Is there anyway of disabling the File/ Save As option from the toolbar in Excel. I want to force the user to use a CommandButton save macro in the form I have developed. Thanks -- Andy T |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can't save newly opened files | Excel Discussion (Misc queries) | |||
| Force save as | Excel Discussion (Misc queries) | |||
| What does Insert>name>LABEL option do ? | Excel Discussion (Misc queries) | |||
| Can't save chart as object in current sheet | Charts and Charting in Excel | |||
| How do I save a record from an excel template to a database in a . | Excel Discussion (Misc queries) | |||
Linear Mode
