Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
When "Save As" is selected
Okay....if a user selects "Save As" from the menu, I
would like to display a message that states "Save As is disabled!" I pretty much want to prevent the "Save As" menu option from being selected. Is this gonna be possible??? thank you everyone |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
When "Save As" is selected
Robert,
Try this, Alt+F11 to open VB editor and double click 'ThisWorkbook' and paste the code in on the right Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) If SaveAsUI Then MsgBox "Save As isn't allowed" Cancel = True End If End Sub Mike "Robert Crandal" wrote: Okay....if a user selects "Save As" from the menu, I would like to display a message that states "Save As is disabled!" I pretty much want to prevent the "Save As" menu option from being selected. Is this gonna be possible??? thank you everyone . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selecting "Save As" adds "Copy of" to file name- MS Excel 2007 | Excel Discussion (Misc queries) | |||
"CELL("FILENAME") NOT UPDATE AFTER "SAVE AS" ACTION | Excel Discussion (Misc queries) | |||
"Save" and "Save As" options greyed out - "Save as Webpage" option | Excel Discussion (Misc queries) | |||
if "a" selected from dropdown menu then show "K" in other cell | Excel Worksheet Functions | |||
"Subscript out of range" error for: Workbooks("Test1.xls").Save | Excel Programming |