ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Fill Color Won't Be Edited (https://www.excelbanter.com/excel-discussion-misc-queries/157779-fill-color-wont-edited.html)

jgraves

Fill Color Won't Be Edited
 
I am using Excel 2003. I have a workbook with several sheets. On one sheet, I
have a column that shows about 25 cells colored turquoise. When I select them
and choose "No Fill" or white for fill, it changes to what I select. As soon
as I switch to another sheet, then return, the turquoise has returned.
I have checked protection, closed and relaunched the sheet, even rebooted my
machine - to no avail. I have tried deleting and recreating the column and it
still remains in the same range as before I deleted.
Help! What is going on here?

Jim May

Fill Color Won't Be Edited
 
Perhaps there is Activate Event Code attached to this sheet. Check the code
behind the sheet

"jgraves" wrote:

I am using Excel 2003. I have a workbook with several sheets. On one sheet, I
have a column that shows about 25 cells colored turquoise. When I select them
and choose "No Fill" or white for fill, it changes to what I select. As soon
as I switch to another sheet, then return, the turquoise has returned.
I have checked protection, closed and relaunched the sheet, even rebooted my
machine - to no avail. I have tried deleting and recreating the column and it
still remains in the same range as before I deleted.
Help! What is going on here?


jgraves

Fill Color Won't Be Edited
 
That did it! Thank you. I thought I was going crazy.

"Jim May" wrote:

Perhaps there is Activate Event Code attached to this sheet. Check the code
behind the sheet

"jgraves" wrote:

I am using Excel 2003. I have a workbook with several sheets. On one sheet, I
have a column that shows about 25 cells colored turquoise. When I select them
and choose "No Fill" or white for fill, it changes to what I select. As soon
as I switch to another sheet, then return, the turquoise has returned.
I have checked protection, closed and relaunched the sheet, even rebooted my
machine - to no avail. I have tried deleting and recreating the column and it
still remains in the same range as before I deleted.
Help! What is going on here?



All times are GMT +1. The time now is 03:59 PM.

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