1 12:07 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ How to remove Save As opiton from excel.
Please let me know how i can remove save as option from excel file...I have
restrict persons not to save as an
Hi
Pls find the code.
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean)
If SaveAsUI Then
Cancel = True
End If
End Sub
This will work only if the workbook has been saved once.
On Fri, Jul 22, 2011 at 12:07 AM, Anshul wrote:
> Please let me know how i can remo
Please let me know how i can remove save as option from excel file...I have
restrict persons not to save as anexcel file.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links