Disable "Save As" Option

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
You must log in or register to reply here.

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

How can we convert OST to PDF file format? 1
Disable Macro Alert 2
What are the steps to fix damaged MDF files in SQL Server? 0
Assign Macro to Icon on toolbar 3
Disable 'save' command in Excel 2000 7
Excel And Notepad 3
CommandButton as array ? 2
Disable the save button 4

Back
Top