View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default Change color of already shaded cells

Ok, a couple of other possibilities.

The sheet may be protected or there may be some VBA code doing this.

Goto the menu ToolsProtection. Is there an option to Unprotect?

Look for any macros (VBA code)

Hit ALT F11 to open the VBA editor
Goto ViewProject Explorer
Locate your file name

Do you see any modules listed?

Double click the sheet name. Do you see any code in the window that opens?

Biff

"Scotty J" wrote in message
ups.com...
I did this, and it says there is "No Format Set".