-
Solved: Click on protected sheet
I have a WB, and one of the worksheets is used to only display status, inputs, results, with no user input on that WS allowed
It's protected with Allow User to select Locked Cells and Unlocked Cells not checked, since it's the VBA that updates data on it
Invariably someone will try to click on the the 'display only' cells and try to enter data on this Summary Only WS.
Then I get a call saying "I need the password" or "I can't enter data" etc.
What would be nice is if I could response to the click on the protected WS and popup something about the importance of following instructions
There is not a OnClick event that I can find, so I'm looking for ideas
Paul
Edit: There is a DoubleClick event that can be captured, but no single click
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules