Prevent User from saving
 

How to enable user to key in data but doesnt allow them to save?

Prevent User from saving
 

In the ThisWorkbook module, use the following code:

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, _
Cancel As Boolean)
Cancel = True
End Sub


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"crapit" wrote in message
...
How to enable user to key in data but doesnt allow them to
save?

Prevent User from saving
 

Thanks.
In addition, does protecting the sheet allow data to be enter? Can it be use
to prevent resizing the height/width of cell but
"Chip Pearson" wrote in message
...
In the ThisWorkbook module, use the following code:

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, _
Cancel As Boolean)
Cancel = True
End Sub


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"crapit" wrote in message
...
How to enable user to key in data but doesnt allow them to
save?