View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
caldog caldog is offline
external usenet poster
 
Posts: 111
Default Buttons they are moving on Me

I have used this worksheet for several months, and in this sheet I have
included a couple buttons. Today when I print this sheet out , the buttons
moved to another location on the sheet.

Here is my code that I have used on button one:

Private Sub CommandButton2_Click()
Range("B3").Select
ActiveWindow.ScrollRow = 2
ActiveWindow.FreezePanes = True
End Sub

And button two is using this code:

Private Sub CommandButton3_Click()
ActiveWindow.FreezePanes = False
Range("A2").Select
ActiveWindow.ScrollRow = 1
End Sub

Can somebody tell me why these buttons just now are deciding to move after
printing.

Steve