Decimal place + - button use in protected worksheet  
Author Message
lontrademaria





PostPosted: Tue Jul 24 21:16:31 CDT 2007 Top

worksheet functions >> Decimal place + - button use in protected worksheet

Hi,

I have one cell that I need to manually nudge up or down the decimal
place for by using the quick button on the top menu.

Problem is my workbook has protected sheets, and all formatting
functions vanish when you protect.

How can I allow users to change the DP in this one cell in my
protected sheet?

Currently I unprotect, change the DP and reprotect.

Cheers,

Aaron.

Excel479  
 
 
Gord





PostPosted: Tue Jul 24 21:16:31 CDT 2007 Top

worksheet functions >> Decimal place + - button use in protected worksheet Unlock that cell before protecting the sheet.

Format>Cells>Protection

Allow users to format that cell.

Tools>Protection>Protect Sheet.

Enable "format cells"

If not using 2002 or newer you won't have this option so could use VBA code to
unprotect, do the deed then re-protect.


Gord Dibben MS Excel MVP



>Hi,
>
>I have one cell that I need to manually nudge up or down the decimal
>place for by using the quick button on the top menu.
>
>Problem is my workbook has protected sheets, and all formatting
>functions vanish when you protect.
>
>How can I allow users to change the DP in this one cell in my
>protected sheet?
>
>Currently I unprotect, change the DP and reprotect.
>
>Cheers,
>
>Aaron.

 
 
Aaron





PostPosted: Tue Jul 24 21:26:24 CDT 2007 Top

worksheet functions >> Decimal place + - button use in protected worksheet
> Unlock that cell before protecting the sheet.
>
> Format>Cells>Protection
>
> Allow users to format that cell.
>
> Tools>Protection>Protect Sheet.
>
> Enable "format cells"
>
> If not using 2002 or newer you won't have this option so could use VBA code to
> unprotect, do the deed then re-protect.
>
> Gord Dibben MS Excel MVP
>
>
>

> >Hi,
>
> >I have one cell that I need to manually nudge up or down the decimal
> >place for by using the quick button on the top menu.
>
> >Problem is my workbook has protected sheets, and all formatting
> >functions vanish when you protect.
>
> >How can I allow users to change the DP in this one cell in my
> >protected sheet?
>
> >Currently I unprotect, change the DP and reprotect.
>
> >Cheers,
>
> >Aaron.- Hide quoted text -
>
> - Show quoted text -

I am using Excel 2007,

The cell is unlocked as it can have a number entered into it, but I
also want to be able to change the DP of that cell.

The format menu is not available when the sheet is protected and the
cell is unlocked as you can edit the contents, just not the format.

Cheers,

Aaron.

 
 
Gord





PostPosted: Tue Jul 24 21:31:36 CDT 2007 Top

worksheet functions >> Decimal place + - button use in protected worksheet Sorry

I don't use 2007 but 2002 and 2003 allowed cell formatting in unlocked cells on
a protected sheet.

Perhaps a 2007 user will jump in with some info.


Gord




>> Unlock that cell before protecting the sheet.
>>
>> Format>Cells>Protection
>>
>> Allow users to format that cell.
>>
>> Tools>Protection>Protect Sheet.
>>
>> Enable "format cells"
>>
>> If not using 2002 or newer you won't have this option so could use VBA code to
>> unprotect, do the deed then re-protect.
>>
>> Gord Dibben MS Excel MVP
>>
>>
>>

>> >Hi,
>>
>> >I have one cell that I need to manually nudge up or down the decimal
>> >place for by using the quick button on the top menu.
>>
>> >Problem is my workbook has protected sheets, and all formatting
>> >functions vanish when you protect.
>>
>> >How can I allow users to change the DP in this one cell in my
>> >protected sheet?
>>
>> >Currently I unprotect, change the DP and reprotect.
>>
>> >Cheers,
>>
>> >Aaron.- Hide quoted text -
>>
>> - Show quoted text -
>
>I am using Excel 2007,
>
>The cell is unlocked as it can have a number entered into it, but I
>also want to be able to change the DP of that cell.
>
>The format menu is not available when the sheet is protected and the
>cell is unlocked as you can edit the contents, just not the format.
>
>Cheers,
>
>Aaron.

 
 
Aaron





PostPosted: Tue Jul 24 21:39:44 CDT 2007 Top

worksheet functions >> Decimal place + - button use in protected worksheet
> Sorry
>
> I don't use 2007 but 2002 and 2003 allowed cell formatting in unlocked cells on
> a protected sheet.
>
> Perhaps a 2007 user will jump in with some info.
>
> Gord
>
>
>


> >> Unlock that cell before protecting the sheet.
>
> >> Format>Cells>Protection
>
> >> Allow users to format that cell.
>
> >> Tools>Protection>Protect Sheet.
>
> >> Enable "format cells"
>
> >> If not using 2002 or newer you won't have this option so could use VBA code to
> >> unprotect, do the deed then re-protect.
>
> >> Gord Dibben MS Excel MVP
>

> >> >Hi,
>
> >> >I have one cell that I need to manually nudge up or down the decimal
> >> >place for by using the quick button on the top menu.
>
> >> >Problem is my workbook has protected sheets, and all formatting
> >> >functions vanish when you protect.
>
> >> >How can I allow users to change the DP in this one cell in my
> >> >protected sheet?
>
> >> >Currently I unprotect, change the DP and reprotect.
>
> >> >Cheers,
>
> >> >Aaron.- Hide quoted text -
>
> >> - Show quoted text -
>
> >I am using Excel 2007,
>
> >The cell is unlocked as it can have a number entered into it, but I
> >also want to be able to change the DP of that cell.
>
> >The format menu is not available when the sheet is protected and the
> >cell is unlocked as you can edit the contents, just not the format.
>
> >Cheers,
>
> >Aaron.- Hide quoted text -
>
> - Show quoted text -

Hmm I used to use 2003 but recently upgraded as I hit the too many
cell formats error problem. I have had this problem in 2003 also.

To clarify, I basically have the whole sheet locked, and I allow users
to edit ranges of cells.

When I protect sheet I only allow select unlocked cells.

If I also allow globally format cells they will be able to format all
the other unlocked cells also and I dont want that.

I need to allow this one cell to be formatted only, and even then for
decimal place only if poss.

Cheers,

Aaron.