Protection
1. you can unlock the cells you don't want protected under format cells, and
then protect the sheet
2. use the sheet code name in any code you write, this is one way to assure your
code runs (if that's the reason you want to restrict the name change)
in the vbe, you can see the code name ( and change it) by clicking view and then
properties window. it's the one at the top with name in the ()
--
Gary
"Gregc." wrote in message
oups.com...
Hi
I have two questions.
The first one: is it possible to protect certain parts and not the
whole worksheet and,
The second one: is it possible to prevent a person changing the name of
a worksheet.
Thanks
Greg
|