Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell Protection
Isy,
You can do this only via VBA. Try Worksheets(1).Protect UserInterfaceOnly:=True,Password:="whatever" Note that the UserInterfaceOnly property doesn't persist after the workbook is closed, so you should execute this code in the Auto_Open procedure or the Workbook_Open event in order to re-protect every time the workbook is opened. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Isy Taman" wrote in message ... Is there a way of protecting cells in a worksheet that will prevent changes to a cell from keyboard entries but WILL allow changes if it's through Vba code. Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Data Protection Best Practice: AKA: Real Sheet Protection | Excel Discussion (Misc queries) | |||
Excel Data Protection- AKA: Sheet/Macro Password Protection | Setting up and Configuration of Excel | |||
Password Protection - paste to unprotected cell locks the cell | Excel Discussion (Misc queries) | |||
Cell Protection vs. Worksheet Protection | Excel Discussion (Misc queries) | |||
Cell Protection | Excel Discussion (Misc queries) |