Occasionally losing the scroll bar function...weird

  • Thread starter Thread starter miker1999
  • Start date Start date
M

miker1999

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
 
Please help, if you can...this is causing user-frustration. Thanks
bunch
 
based on the detailed description of the problem, i would suggest isolating
the cause of the problem and avoiding it.
 
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

Scroll Bar- Move one cell to right 1
Auto Freeze Frame 2
Moving entire workbooks scroll bars 1
Scroll Bars on Worksheet 1
Scroll bar (control) doesn't scroll!! ??? 3
Scroll bar update 1
What to use other than .Select 2
Force Scroll Bar Down on TextBox Control 5

Back
Top