cell protection
 

Maybe you could hide those names from the users.

You may want to get a copy of Jan Karel Pieterse, Charles Williams and Matthew
Henson's utility called NameManager. It'll allow you (and anyone else who has
a copy) to toggle the visibility of each name.

You can find it at:
http://www.bmsltd.ie/mvp

And if you're lucky, the users won't even try to change the names that they
can't see.

(But users could still screw up the names--deleting a named range may screw up
your code.)

William wrote:

hi,

in an excel worksheet, i give names to the cells that i work with. and, the
cells can be referenced by names from a word vba program later. in excel for
xp, how can i protect the names of the cells from being changed and deleted,
but users can still change the contents of the cells? if not, what's the
alternative?

thank you,

william.

--


--

Dave Peterson

cell protection
 

thanks for the hint. dave. william

"Dave Peterson" wrote:

Maybe you could hide those names from the users.

You may want to get a copy of Jan Karel Pieterse, Charles Williams and Matthew
Henson's utility called NameManager. It'll allow you (and anyone else who has
a copy) to toggle the visibility of each name.

You can find it at:
http://www.bmsltd.ie/mvp

And if you're lucky, the users won't even try to change the names that they
can't see.

(But users could still screw up the names--deleting a named range may screw up
your code.)

William wrote:

hi,

in an excel worksheet, i give names to the cells that i work with. and, the
cells can be referenced by names from a word vba program later. in excel for
xp, how can i protect the names of the cells from being changed and deleted,
but users can still change the contents of the cells? if not, what's the
alternative?

thank you,

william.

--


--

Dave Peterson