Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Dear Experts,
I have a workbook which contains some VBA "Worksheet_Change" code. Basically, when a user makes a change in a certain cell, the cell next to it changes to reflect the name of this user. This is a security check for me, to make sure that the person who has actually inputed the cell is also the one allowed to do so. But the cell containing his/her name must be protected, otherwise everybody can change it... only when I try to do so, I get an error from the Worksheet_Change code, as it's not allowed anymore to input the name in the protected cell. Is there a way I can allow VBA to write in these otherwise protected cells for everybody else? I hope I was clear, if not please let me know and I'll rephrase my problem! Thanks in advance for your precious and needed help! Best regards, -- Valeria |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
CD Writer | New Users to Excel | |||
PDF writer | Excel Discussion (Misc queries) | |||
PDF Writer Error | Excel Programming | |||
Adobe PDF Writer error | Excel Programming | |||
Cheque Writer in Excel | Excel Programming |