I am using a macro which saves a file automatically to the Desktop. What I would like to do is disable Save/Save As using VBA code immediately after the file is automatically saved to prevent it from being saved again. I would also like to disable the 'Save/Save As' window from opening when the file is closed. I have tried using the 'Before_Save' and 'Before_Close' events but the 'Before_Save' event prevents the macro from automatically saving the file. Could this be done using some lines of code in my macro rather than using the 'Before' events? I then need some code to enable 'Save/Save As' in another macro. Any suggestions would be greatly appreciated.
Also posted at: http://www.mrexcel.com/forum/excel-q...ml#post3485698
Bookmarks