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".
|