sidwelle
asked on
freeze panes in excel w/o select
I am using the following lines of code to freeze panes on a sheet, but it has to get focus of the sheet.
Is there anyway to freeze panes w/o activating a current sheet and acting on a selection ?
Is there anyway to freeze panes w/o activating a current sheet and acting on a selection ?
Sheets(SheetName).Rows("2:2").Select
ActiveWindow.FreezePanes = True
Why do you need to freeze the panes of a sheet that you are not looking at?
ASKER
I plan to look at it as soon as my script is done populating it.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I plan to look at it as soon as my script is done populating it.So do the freezing after that.
ASKER
I am creating several new sheets via script, don't want to go do it every time for every sheet.
is there anyway of freezing panes w/o using the "ActiveWindow" ?
What object does the "freezepanes" method really belong to ?
is there anyway of freezing panes w/o using the "ActiveWindow" ?
What object does the "freezepanes" method really belong to ?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for the help, all the code seems to be about the same. I liked Shums solution the best by checking if anything is frozen fist.
Thanks
Thanks
ASKER
Thanks for the help, all the code seems to be about the same. I liked Shums solution the best by checking if anything is frozen fist.
Thanks
Thanks