Protecting worksheet elements

K

K. Georgiadis

I have a "market data entry form" providing for data
entry for up to 5 segments in separate sections. Several
fields are calculated and have been locked under password
protection, to prevent the users from overriding the
formulas with hard-coded numbers.

The users have requested the ability to (a) shade any
cells so as to highlight them and (b) to hide rows in the
event that they do not need to complete all 5 segment
sections.

For starters, the "Allow users to..." menu under password
protection does not include an option to hide rows. I
checked the "format rows" box but I found that I can only
do that with rows that are unlocked in the first place.

Am I misinterpreting the menu and am I trying to do
something that cannot be done?
 
F

Frank Kabel

Hi
as a workaround:
- create a macro
- within this macro first unprotect the sheet, hide the selected rows
and protect the sheet again
 
K

K. Georgiadis

After staring at the Tools/Protection options dialog box
for a while, I realized that I had NOT given myself
permission to place the pointer on the locked cells. Once
I allowed myself to do that, I was able to allow
formatting (including hiding) of locked rows. Moral of
the story: I need to remind myself that Excel 2002 can do
a lot more than I realize!

Thanks for the macro but, in this instance, it seems that
the solution was staring me in the face.

KG
 
Top