DP use when sheet protected
 

I have a sheet that when protected, greys out the decimal place
setting buttons up top of the sheet on the menus. Is there a way of
having the decimal place buttons usable when sheet protected?

Cheers,


Aaron.

DP use when sheet protected
 

Aaron,

I have XL2003. When you protect your worksheet, in the "Allow all users of
this worksheet to:" section, check the "Format Cells" checkbox.


--
Hope that helps.

Vergel Adriano


"Aaron" wrote:

I have a sheet that when protected, greys out the decimal place
setting buttons up top of the sheet on the menus. Is there a way of
having the decimal place buttons usable when sheet protected?

Cheers,


Aaron.

DP use when sheet protected
 

Uzytkownik "Aaron" napisal w wiadomosci
ups.com...
|I have a sheet that when protected, greys out the decimal place
| setting buttons up top of the sheet on the menus. Is there a way of
| having the decimal place buttons usable when sheet protected?
|

I think, you need to write your own routines to handle this issue, and then
assign them to your custom buttons or menus.

your routine should

1. unlock your sheet
2. set the format you need
3. lock your sheet

cheers :)