View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dannycol
 
Posts: n/a
Default How to prevent warning messages on protected work sheet.

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.