Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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 :) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |