I press a control button, on occasion about 1/3 of the left side columns turn
grey. I do not get a VBA error and the macro exits gracefully as planned.
At this point, I have to close the spreadsheet, close Excel, reopen Excel and
reopen spreadsheet to view the left side columns. Does anyone know how to
prevent this from occurring?
--
rjwilcox

Let us see some code from the macro and we will be better able to help.
--
Best wishes,

Jim


"rjwilcox" wrote:

I press a control button, on occasion about 1/3 of the left side columns turn
grey. I do not get a VBA error and the macro exits gracefully as planned.
At this point, I have to close the spreadsheet, close Excel, reopen Excel and
reopen spreadsheet to view the left side columns. Does anyone know how to
prevent this from occurring?
--
rjwilcox

Jim,

After I saw your response, I did some more research and I think I
solved the problem. In the spreadsheet where the error occurs all
sheets are protected. If I unprotect the sheets before I begin the
macro, the greying or ghosting does not occur.

Thanks

Jim Jackson wrote:
Let us see some code from the macro and we will be better able to help.
--
Best wishes,

Jim


"rjwilcox" wrote:

I press a control button, on occasion about 1/3 of the left side columns turn
grey. I do not get a VBA error and the macro exits gracefully as planned.
At this point, I have to close the spreadsheet, close Excel, reopen Excel and
reopen spreadsheet to view the left side columns. Does anyone know how to
prevent this from occurring?
--
rjwilcox