Can I freeze pane on an inactive worksheet?

  • Thread starter Thread starter Mcubitt
  • Start date Start date
M

Mcubitt

In VBA it is possible to set a point to "freeze panes". Can this be
applied to a non-active worksheet?

Thanks
 
Freeze Panes is the only operation that requires that you select
a cell, thus you can't freeze panes on an inactive worksheet.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
You must log in or register to reply here.

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

PowerPoint Freeze animation 1
Worksheet activation on Opening Workbook 2
Can I find out if & where "Freeze Panes" is set 4
Freeze Panes loss 3
Allow Users to Unfreeze Panes in a Protected Workbook/Sheet 2
Saving freeze pane worksheet 2
Excel Freeze panes in Excel 3
Freeze panes 4

Back
Top