security of a cell

C

chimp

is it possible to protect a range of cells, so that it i wanted to
change them a box could appear requesting the password to access the
cells.

i would idelly like to set this up so that the need to go through the
top menu is bypassed.
 
D

Dave Peterson

This was added in xl2002 as a built in feature.

Before that version, you'd need a macro. And if the user opened the workbook
without enabling macros, it wouldn't be effective.
 
Top