| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Prevent User from saving
How to enable user to key in data but doesnt allow them to save?
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Prevent Saving | Excel Discussion (Misc queries) | |||
| Prevent user from saving workbook | Excel Discussion (Misc queries) | |||
| Saving a Workbook: Forcing User to Rename before Saving | Excel Programming | |||
| prevent user from saving file to a folder but allow my code to save from behind. | Excel Programming | |||
| prevent user from saving excel file to a folder | Excel Programming | |||
Linear Mode
