When "Save As" is selected

  • Thread starter Thread starter Robert Crandal
  • Start date Start date
R

Robert Crandal

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Detect "Save" menu event 1
Forcing Macros to Run 2
having trouble disabling "save", "save as" (2003) 6
Checking if some cells are empty when file is being saved 1
Disable save & save as then return message... 2
Disable Save 5
Save as PDF in Office 7
programming in vb.net application 1

Back
Top