View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
GS GS is offline
external usenet poster
 
Posts: 364
Default Disable the prompt when clicking on a protected cell?

Hi Frank,

AFAIK: This is a feature of sheet protection. You can't suppress this alert.

Regards,
GS


" wrote:

Hi all,

I have protected the worksheet to avoid any unwanted user intervention.
Then I was told to remove the corresponding message box when a user
attempts to modifed such a protected cell, i.e. When such an attempt
happens, Excel does NOTHING, rather than displaying a message telling
the user

"the cell or chart you are trying to change is protected and therefore
read-only...
<How to modify it.."

So how can this message be stopped from being seen by the user? Thanks
any help will be appreciated.

Regards
Frank