View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Aaron Aaron is offline
external usenet poster
 
Posts: 59
Default 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.