Does anyone know the code for turning off "save" and "save as" functions for MS Excel 2007 so one cannot use those functions in drop down menu, shortcut keys and on the Ribbon?
Thanks,
Scott
Does anyone know the code for turning off "save" and "save as" functions for MS Excel 2007 so one cannot use those functions in drop down menu, shortcut keys and on the Ribbon?
Thanks,
Scott
For that you will have to download Visual Studio 2008 and enter the code that is given below:
Code:Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) MsgBox "The 'Save As' function has been disabled." Cancel = True End Sub
It's working. Thanks. Now, I was wondering, how do you disable cut, copy and paste functions. I have found a way to do it for shortcuts, drop down menus, pop up menus, but not disable it from the ribbon. Can you help me on this?
Thanks,
Scott
Bookmarks