Re: $$Excel-Macros$$ Disable saveas option

Hi Manjunath, We can not disable the save option of any excel file without using VBA, But in case of VBA Just Write the below metioned Code Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) Cancel = True End Sub Regards Prince On Tuesday, March 5, 2013 11:53:2

Re: $$Excel-Macros$$ Disable saveas option

Hi manjunath, Use the following code. Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) If SaveAsUI = True Then Cancel = True End Sub On Tue, Mar 5, 2013 at 11:53 PM, Manjunath Narayanappa < manjunath.n1...@gmail.com> wrote: > Dear Experts > >

$$Excel-Macros$$ Disable saveas option

Dear Experts I have disable SAVEAS option from excel Thanks Manjunath -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thr