Columns hide them selves

K

kim

Excel 2003. a colleague hasa worksheet. H e unhides columns saves but
sometimes when it is re opened the columns are hidden again.
Any ideas what can be causing this. There is no Protection or conditional
formulas on the sheet.
 
D

Dave Peterson

Maybe the workbook contains a macro that sets columnwidths when it opens. Or
even when the worksheet is activated.

You can open the workbook
hit alt-f11 to get to the VBE
hit ctrl-f4 to see the project explorer
Select your project and hit the asterisk on the numeric keypad to expand all the
branches.

and look for code under the ThisWorkbook, or under the associated sheet module,
or a subroutine named Auto_open in any of the general modules.
 
Top