Excel freezePanes not on non-active Workshhet

G

GadyC

I look for a way to set freezepane on non-active worksheets rather than on
activewindow.

is there any way to do that?
 
J

Jim Thomlinson

One of the very few situations where you need to select the sheet. There is
no way around it.
 

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

FreezePanes not working when chart present 1
Late Binding Excel: Exception when use FreezePanes to format a she 0
Help with Excel FreezePanes from code 2
Problem activating pre-installed MS Office home and Student 0
Outlook 365 overriding formatting choices 0
FreezePanes in Excel called from MS Project by VBA 4
Freezepanes odd behavior 1
Copy addition formula of non-consecutive horizontal cells 2

Top