View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
keepITcool keepITcool is offline
external usenet poster
 
Posts: 2,253
Default SAVE AS menu option


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