Hi guys,
I'm in the final stages of creating a workbook, but along the way I've inadvertently made some odd changes to some of the sheets.
For context, the workbook has protection but it is unlocked, and it also has a fairly substantial amount of VBA attached. As far as I am aware, none of the VBA relates to the problem I am having.
Some sheets are missing columns. They are not hidden, rather just missing all together!? On one sheet for example, the column headings stop completely after column "U" - No columns appears afterward. I've searched Mr Excel, as well as other forums, and tried every suggestion I can find relating to un-hiding them, unfreezing panes, etc. Nothing has worked for me yet.
These sheets also prevent me from selecting a column or row by clicking on the row/column heading. When I click a heading, or try to select multiple rows or headings (clicking and dragging along the desired rows/columns headings), the active cell remains highlighted (instead of highlighting the selected column/s or row/s), and nothing else happens. I can still hide/unhide rows on these sheets, but only using the position of the active cell.
To save a lot of back and forth explanation on an odd error, is there a way I can attach my sheet to this thread for inspection...?
As always, everyone's help is greatly appreciated. Cheers.
I'm in the final stages of creating a workbook, but along the way I've inadvertently made some odd changes to some of the sheets.
For context, the workbook has protection but it is unlocked, and it also has a fairly substantial amount of VBA attached. As far as I am aware, none of the VBA relates to the problem I am having.
Some sheets are missing columns. They are not hidden, rather just missing all together!? On one sheet for example, the column headings stop completely after column "U" - No columns appears afterward. I've searched Mr Excel, as well as other forums, and tried every suggestion I can find relating to un-hiding them, unfreezing panes, etc. Nothing has worked for me yet.
These sheets also prevent me from selecting a column or row by clicking on the row/column heading. When I click a heading, or try to select multiple rows or headings (clicking and dragging along the desired rows/columns headings), the active cell remains highlighted (instead of highlighting the selected column/s or row/s), and nothing else happens. I can still hide/unhide rows on these sheets, but only using the position of the active cell.
To save a lot of back and forth explanation on an odd error, is there a way I can attach my sheet to this thread for inspection...?
As always, everyone's help is greatly appreciated. Cheers.
Last edited:
