Hello,
In my workbook, when it is opened, I use the following code t
automatically freeze the panes for each sheet.

Private Sub Freeze_Frames()
ActiveWindow.SplitRow = 2
ActiveWindow.FreezePanes = True
End Sub

Now, occasionally, I lose the side scroll bar function and I can n
longer scroll up or down. I can see the little bar moving (ever s
slowly), but the actual sheet does not move. The only fix it to clos
the workbook and reopen and it is fine.

What gives? Help please, this is annoying. There is no set pattern o
when/why this happens.

Thanks in advance,
Mik

--
Message posted from http://www.ExcelForum.com