Logo 
Search:

MS Office Answers

 Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Mona Mehta   on Oct 03 In MS Office Category.

help with freezing panes so labels scroll with the page macro


  
Question Answered By: Constance Reid   on Oct 03

I had to update the screen before I used FreezePanes.

My code snippet is:

' !!NOTE: Screen has to be updated to place
' the freeze in the correct location!
' restore screen updates and postion screen to top left of data
Application.ScreenUpdating = True
Range("A8").Activate
ActiveWindow.FreezePanes = True

Share: 

 

This Question has 2 more answer(s). View Complete Question Thread

 


Tagged: