View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Valeria Valeria is offline
external usenet poster
 
Posts: 127
Default protect a worksheet for everybody except the VBA writer

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