PDA

View Full Version : [SOLVED] Lock (freeze?!) objects



luizmachado
01-11-2016, 08:17 PM
Is there any way to freeze more than once? I have this "Monthly Expenses" workbook where I froze the third row, then all rows above are froze, but I can't freeze anything more. When I try to freeze this table and this chart on the right, the "Freeze panes" option isn't available.
Do you guys know anything I can do to solve it (it can be the standard way or VBA way)?
I, basically, want to keep the third row froze and freeze the table and chart on the right, this way I can always keep my eye on these informations.

15144

alansidman
01-11-2016, 11:17 PM
crosspost: http://www.excelforum.com/excel-programming-vba-macros/1121198-lock-freeze-objects.html

Paul_Hossler
01-12-2016, 08:01 AM
Possible way would be to create New Window and then Arrange Vertically. Not great, but maybe good enough

15145

luizmachado
01-12-2016, 12:16 PM
Thank youu!! As you said, it isn't great, but enough.