Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sheet Information - Is sheet protected? | Excel Discussion (Misc queries) | |||
Is sheet protected | Excel Programming | |||
Protected sheet to unprotected sheet | Excel Worksheet Functions | |||
protected sheet | Excel Discussion (Misc queries) | |||
excel - macro code to open a protected sheet, enter passowrd, and then protect sheet | Excel Programming |