Lelf Columns Turns Grey

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Let us see some code from the macro and we will be better able to help.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

My Excel Options button is greyed out (Excel 2007) How to turn it 1
Left Side of Excel Screen Turns Gray 2
Screen repainting issue 2
Turn Off automatic parsing of data in Excel 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
bringing up a window to make header row selections 2
Excel Crash and/or Gray Area on Screen 5
Hyperlink creation problem 2

Back
Top