ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   HELP Excel 2007. Background Colour tabs blocked? (https://www.excelbanter.com/excel-discussion-misc-queries/162985-help-excel-2007-background-colour-tabs-blocked.html)

Mantis2k

HELP Excel 2007. Background Colour tabs blocked?
 
Good Morning.

I seem to be having a bit of trouble trying to allow a user to use the
background colour button in excel 2007. The user wants to colour certain
cells in their spreadsheet but are unable to as the buttons you would
normally use are ghosted out (unable to be used). Is there anyway to allow
this. Im an excel 2003 user so 2007 is a very new experience for me.

Anyones help would be much appreciated.
--
Stuart Henry
Stage Systems

Roger Govier[_3_]

HELP Excel 2007. Background Colour tabs blocked?
 
Hi

Colouring the cells is the same as in XL2003.
It sounds as though their sheet is protected.
Right click on sheet tabUnprotect

--
Regards
Roger Govier



"Mantis2k" wrote in message
...
Good Morning.

I seem to be having a bit of trouble trying to allow a user to use the
background colour button in excel 2007. The user wants to colour certain
cells in their spreadsheet but are unable to as the buttons you would
normally use are ghosted out (unable to be used). Is there anyway to allow
this. Im an excel 2003 user so 2007 is a very new experience for me.

Anyones help would be much appreciated.
--
Stuart Henry
Stage Systems





All times are GMT +1. The time now is 11:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com