Thread: Disable Save and Save As
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Rob Rob is offline
external usenet poster
  
Posts: 234
Default Disable Save and Save As
Thanks very much, works a treat. Rob
"PosseJohn" wrote in message
...
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean)

Cancel = True

End Sub


Reply With QuoteReply With Quote