MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Save Operation

Posted by Ali on January 22, 2001 9:29 AM


I have written to a custom procedure for the Save operation.
I have assigned that procedure to Save shortcut "Ctrl+s" as
application.onkey "^{s}", "fSaveFile_new".

But when I double click on a cell and press the Ctrl+s from keyboard
the standard Save dialog box appears.

Please let me how to overcome this problem.

THanks a lot

Posted by Dave Hawley on January 22, 2001 10:50 PM

Hi Ali

To prevent the use of the Save As dialog put this code in the Workbook_BeforeSave event. Right click on the sheet picture top left, next to "File" and select "View Code" then select BeforeSave from the procedure box.

IF SaveAsUI=True then Cancel=True

Hope this helps


OzGrid Business Applications

Posted by Ali on January 23, 2001 11:59 AM

Thanks a lot Dave...:):)

Thanks a lot Dave...:):)