Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Module updating of Protected Cells
Is it possible to have a cell updated using a VBA module while the cell is
protected? I have a module that inputs the date/time in a field when a user inputs information into another field. I want to protect the date/time so that the user can not alter it. I am using Excel 2003. Thanks for the help. |
#2
|
|||
|
|||
Hi
no, you'll need to unprotect the sheet, undate the cell and then re-protect the sheet - this can all be done in code e.g. activesheet.unprotect "pwd" 'your code here activesheet.protect "pwd" use your password instead of pwd or delete if not required Cheers JulieD "GaryByrd" wrote in message ... Is it possible to have a cell updated using a VBA module while the cell is protected? I have a module that inputs the date/time in a field when a user inputs information into another field. I want to protect the date/time so that the user can not alter it. I am using Excel 2003. Thanks for the help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Locked cells not updating | Excel Worksheet Functions | |||
Auto Skipping and protected cells | Excel Discussion (Misc queries) | |||
Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) | |||
Protected cells -automatically format to a different color | Excel Discussion (Misc queries) | |||
Excel 2003 isn't updating my cells | Excel Worksheet Functions |