Protecting Selected Cells and Functions

[Gunjani]

I have a worksheet. In Cell B2 is a Data validation box Listing a range
of colleagues names( DRop Down Menu). On selection of a name in B2, the
contents of the whole worksheet changes.

I like to Protect the worksheet for:

1) Hiding the formulaes
2) And most importantly preventing editing of the contents of any other
cell (except B2).

and yet be permiitted to:

3) Select contents in Cell B2 (Data Validation Box)
4) Select Auto filters in Row 4

I've tried using the the Tools/ Protect worksheet menu, ticking Select
Lock Cells, Select Unlock cell, use auto filters. And in in
Format/Cells/Protection, Tick in Lock and Hedden boxes.

All the above work except No 3. I am unable to make a selction from the
drop down menu in Cell B2.

Please Any suggestions.

If it is to be done in Macro Please provide me a detailed Idiot Guide
as I have NEVER PERFORMED/USED a Macro, and would not know where to
start.

THX
Gunjani

 

[Dave Peterson]

Try unlocking B2 (Format|cells|protection tab)

I have a worksheet. In Cell B2 is a Data validation box Listing a range
of colleagues names( DRop Down Menu). On selection of a name in B2, the
contents of the whole worksheet changes.

I like to Protect the worksheet for:

1) Hiding the formulaes
2) And most importantly preventing editing of the contents of any other
cell (except B2).

and yet be permiitted to:

3) Select contents in Cell B2 (Data Validation Box)
4) Select Auto filters in Row 4

I've tried using the the Tools/ Protect worksheet menu, ticking Select
Lock Cells, Select Unlock cell, use auto filters. And in in
Format/Cells/Protection, Tick in Lock and Hedden boxes.

All the above work except No 3. I am unable to make a selction from the
drop down menu in Cell B2.

Please Any suggestions.

If it is to be done in Macro Please provide me a detailed Idiot Guide
as I have NEVER PERFORMED/USED a Macro, and would not know where to
start.

THX
Gunjani