ExcelBanter - Excel freezePanes not on non-active Workshhet

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Excel freezePanes not on non-active Workshhet (https://www.excelbanter.com/excel-programming/431669-excel-freezepanes-not-non-active-workshhet.html)

GadyC

Excel freezePanes not on non-active Workshhet

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

is there any way to do that?

Jim Thomlinson

Excel freezePanes not on non-active Workshhet

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

Jim Thomlinson

"GadyC" wrote:

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

is there any way to do that?

All times are GMT +1. The time now is 07:50 AM.