not all cells are locked when protect is true for work sheet

  • Thread starter Thread starter Alexandre Brisebois (www.pointnetsolutions.com)
  • Start date Start date
A

Alexandre Brisebois (www.pointnetsolutions.com)

not all cells are locked when protect is true for work sheet how can i
fix that ?

this is how i lock

ActiveSheet.Protect DrawingObjects:=True, Contents:=True,
Scenarios:=True

some cells with comments or empty cells are not protected... how can i
fix this?
 
Alexandre, sounds like some of the cells are not locked, select all the
cells then format, cells, protection, lock
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Alexandre Brisebois (www.pointnetsolutions.com)"
 
thanks paul it was the solutions, now i have about 40 sheets to do this
on ;)

Regards,
Alexandre
 
If those 40 sheets are in the same workbook, you can group the worksheets by:
clicking on the first worksheet tab and ctrl-clicking on the subsequent

or
rightclick on a worksheet tab and choose "select all sheets"

Then hit ctrl-a (twice in xl2003) to select all the cells (on all the grouped
sheets)

format|cell|protection tab
and change the setting to Locked.

And remember to ungroup the sheets (rightclick on one of the tabs and choose
ungroup sheets. (If you forget, then each change you make will be made to each
of the grouped sheets. So be careful.)
 
Back
Top