PDA

View Full Version : Disable "Save" & "SaveAs"



shahabsoltan
07-24-2014, 01:21 PM
hi
How the icon "Save" and "saveAs" to disable it?

GTO
07-24-2014, 02:30 PM
Hi there,

What year/version of Excel are you using; or if this is for a workbook used at work, what are the newest and oldest versions of Excel in use?

I ask, as probably many still use 2003 or earlier, and whole menubar (where the save and saveas icons are) changed in 2007; so the answer would be markedly different depending on version(s) in use.

Another thing to consider is that regardless of whether you can disable a command, what about shortcut key combinations, such as CTRL+S or SHIFT+F12 or etc... ?

Mark

shahabsoltan
07-24-2014, 11:26 PM
hi gto
my version of excel =2010
help me please

westconn1
07-25-2014, 03:12 AM
this will not disable the buttons, but will prevent saving of workbook

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Cancel = True

End Sub

mancubus
07-25-2014, 04:58 AM
the best way, imho, is the customized ribbon specific to your file.

you can download Custom UI Editor to customize the ribbon for your files here:
http://openxmldeveloper.org/blog/b/openxmldeveloper/archive/2009/08/07/7293.aspx


you can find many tutorials or find files to adopt your requirements by googling.
here is one:
http://www.rondebruin.nl/win/section2.htm

it's not an easy task if you are novice and first you need to learn how to use the editor and the basics.