Hi,

I have a spreadsheet where I've used freeze panes to freeze rows 1-8 and columns A-E. The sheet has a lot of columns in it, so I've put in some VBA code and assigned several buttons which when pressed will hide selected columns so the user can quickly navigate to the part of the sheet they are interested in. I also have a button called 'unhide all' which will show all columns in the spreadsheet.

The problem I have is that for some reason, when I hit the 'unhide all' button and try to navigate across the sheet manually using the scroll bar it won't let me. I can still scroll up and down, just not across. Does anyone know why this might be happening?

Thanks

Chris