Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
allow fill color to protected cell
I have a protected sheet and just want to allow the user to paint on it (fill
color) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
allow fill color to protected cell
Rafael, When you protect the sheet, make sure you select the Format Cells option in the list of edit permissions. Unfortunately, this also allows the user to change other things about the format like border, font, etc... HTH Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=563422 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
allow fill color to protected cell
Which version of Excel?
2002 and newer allow cell formatting when protected. ToolsOptionsProtect Sheet. Choose from the options in the dialog box. Gord Dibben MS Excel MVP On Thu, 20 Jul 2006 11:02:01 -0700, Rafael Diaz <Rafael wrote: I have a protected sheet and just want to allow the user to paint on it (fill color) |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
allow fill color to protected cell
Thanks.
Is this an option in Excell 2000 9 SR-1 "SteveG" wrote: Rafael, When you protect the sheet, make sure you select the Format Cells option in the list of edit permissions. Unfortunately, this also allows the user to change other things about the format like border, font, etc... HTH Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=563422 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
allow fill color to protected cell
Thanks.
It is the 2000 version. CanĀ“t find that option in this version. "Gord Dibben" wrote: Which version of Excel? 2002 and newer allow cell formatting when protected. ToolsOptionsProtect Sheet. Choose from the options in the dialog box. Gord Dibben MS Excel MVP On Thu, 20 Jul 2006 11:02:01 -0700, Rafael Diaz <Rafael wrote: I have a protected sheet and just want to allow the user to paint on it (fill color) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Able to overwrite locked cell in protected sheet | Excel Discussion (Misc queries) | |||
Cell Formatting Conditional On Other Cells Fill Color? | Excel Worksheet Functions | |||
Cell Fill Color and text color - changes for recipient | Excel Discussion (Misc queries) | |||
In MS Excel, how do I fill in a column with the same cell from se. | Excel Worksheet Functions | |||
Identifying the Active Fill Color | Excel Discussion (Misc queries) |