Freeze more than once

[luizmachado]

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.

 

[Michael M]

Yo can't freeze 2 locations.....However, have you considered using the Camera tool
Take a snapshot of the chart and pivot table and place in a more suitable location, while you do your work ???
Remember though it is just a photo, and won't refresh if the data changes

 

[luizmachado]

Yo can't freeze 2 locations.....However, have you considered using the Camera tool
Take a snapshot of the chart and pivot table and place in a more suitable location, while you do your work ???
Remember though it is just a photo, and won't refresh if the data changes

Not even with VBA? I'm kinda new on this VBA thing.
I got it, but I need to see the data live. I mean, when I change it on the other table (it's with test values, but I'll link the tables later).

 

[Michael M]

I don't believe so...If you can imagine freezing a horizontal data AND a vertical data....when you scroll down the page, the horizontal data would be ok, but everything to the right that's frozen would be screwed up ( data wise )

 

[luizmachado]

I don't believe so...If you can imagine freezing a horizontal data AND a vertical data....when you scroll down the page, the horizontal data would be ok, but everything to the right that's frozen would be screwed up ( data wise )

Hmm got it. Is there any way that I can lock (freeze?!) from L5:M14 (table) and the chart area? Basically select both of this areas and lock them, so I can see it live.

 

[Smitty]

Welcome to the Board!

It's been noted that you crossposted at VBA Express and at Excel Forum. Please read this: Excelguru Help Site - A message to forum cross posters

 

[luizmachado]

Solved
[SOLVED] Lock (freeze?!) objects