LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
CD Writer Zygy[_3_] New Users to Excel 1 October 30th 07 05:32 PM
PDF writer TomBeard Excel Discussion (Misc queries) 7 January 11th 07 03:15 PM
PDF Writer Error lyric2002 Excel Programming 1 June 26th 04 02:02 AM
Adobe PDF Writer error Lea Excel Programming 2 November 6th 03 10:30 PM
Cheque Writer in Excel Praveen Excel Programming 1 October 28th 03 03:06 PM


All times are GMT +1. The time now is 02:43 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"