That would disable any possibility for users to save their work
under different names.
If you want to prevent users saving a particular workbook
under another name then write an eventhandler for that workbook.
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean)
If SaveAsUI Then
MsgBox "That's a nono"
Cancel = True
End If
End Sub
--
keepITcool
|
www.XLsupport.com | keepITcool chello nl | amsterdam
Mircea Pleteriu wrote :
Hi,
How to disable the File's Save As menu option?
Thanks,
Mircea