How to enable user to key in data but doesnt allow them to save?
C Chip Pearson Jul 26, 2004 #2 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
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
C crapit Jul 26, 2004 #3 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
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
