Unlocked cell formatting

B

Bhuktar S

I have some cells locked & sheet protected. After the sheet is
protected, all formatting tools get inoperative. I want the users to
have choice for formatting unlocked cells. How to solve this?
 
L

litos_aldovea

Hi,

I hope this make sense.

If you go in the menu to TOOLS -> PROTECTION --> PROTECT SHEET

Then you have the chance to allow user to format Cells, Columns and
Rows by ticking in the small square boxes that are right below the
space where you write your password.

So, by ticking in these options you choose what level of protection you
want in your worksheet.

Regards,
Carlos.
 
B

Bhuktar S

I see 'Contents', 'Objects', 'Scenarios' check boxes.
I am using Excel 2000.
Or am I missing something?
Regards
 
L

litos_aldovea

I am sorry, I am using XL 2002, and this functionality is availabe.

I Just checked in 2000 and it is not there. I am afraid I can't help
you any further.

Maybe someone else can provide a way to solve your problem.

Through VBA?

Sorry about that,
Carlos.
 
D

Dave Peterson

You could provide a macro that unprotects the worksheet, formats the cells, and
reprotects the worksheet.

Then the user would run your macro whenever they wanted to format the cell.
 
Top