How to prevent warning messages on protected work sheet.
You can't stop the message from appearing, and it should only appear on a
double-click, not on a single click.
"Dannycol" wrote in message
...
I have protected 3 work sheets and allow users to edit certain ranges, no
problem here, Question is how can you prevent the warning messages (that
read
the sheet is protected etc....) appearing. Every time a user clicks on a
protected cell the messages appear. may not sound a problem though it is
a
nuisance and a constant distraction for those users who are not familiar
with
the sheet. Any help would be appreciated.
|