I have a bit of code that is supposed to prevent users from saving
however, it is also preventing me from saving the workbook with the bi
of code in!! Does anyone have an idea on how to get the workbook to sav
the bit of code (which goes in the workbook module). Code as follows:


Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel A
Boolean)
MsgBox "Can't save"
Cancel = True
End Sub


Thanks

--
kde
-----------------------------------------------------------------------
kdev's Profile: http://www.excelforum.com/member.php...fo&userid=1653
View this thread: http://www.excelforum.com/showthread.php?threadid=31382