VBA Code to Disable Save As (but not Save)

[MikeG]

I would like to only allow the user to Save the file but not Save As to a different name or location. Is it possible to do this?

Thanks,

MikeG

 

[Andrew Poulsom]

You can test the value of SaveAsUI in the Workbook_BeforeSave event procedure. Here's an example from 2002:

http://www.mrexcel.com/forum/excel-questions/22345-disable-%22save%22-option-file-menu.html

 

[Andrew Poulsom]

You can test the value of SaveAsUI in the Workbook_BeforeSave event procedure. Here's an example from 2002:

http://www.mrexcel.com/forum/excel-questions/22345-disable-"save"-option-file-menu.html

 

[MikeG]

You can test the value of SaveAsUI in the Workbook_BeforeSave event procedure. Here's an example from 2002:

http://www.mrexcel.com/forum/excel-questions/22345-disable-"save"-option-file-menu.html

Just the job!

Thanks,

Mike