Does any one know a macro for preventing the user to save

--
Message posted from http://www.ExcelForum.com

A really determined user? No, can't be done. A casual user? In the
Workbook's BeforeSave event, put in the line

Cancel = True

and that will cancel the save.

HTH,
Bernie
MS Excel MVP

"stols121 " wrote in message
...
Does any one know a macro for preventing the user to save?


---
Message posted from http://www.ExcelForum.com/

Hi
one way: Put the following code in your workbook module:
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean)
MsgBox "Saving not allowed"
Cancel = True
End Sub

--
Regards
Frank Kabel
Frankfurt, Germany

Does any one know a macro for preventing the user to save?


---
Message posted from http://www.ExcelForum.com/