Freezepanes

[BadgerMK]

Hi All

I wonder if any kind soul can help me......

I'm trying to automate putting column L to the far left (ie cant see cols A-K, but not wanting them hidden) and then putting Freezepane on at col M.

But everytime I code to move the activecell from say col B to AY, Col L disappears behind the row heading, or if then I select col L the screen then shows from col E?? Yet if I manually move the curser using the arrow keys I can get Col L to be the first left hand Col.

Many thanks

Badger

[mpeplow]

I don't know about everyone else, but I lost you round about here

or if then I select col L the screen then shows from col E?? Yet if I manually move the curser using the arrow keys I can get Col L to be the first left hand Col.

Maybe if you posted a pic or file of your spread sheet and the macro code that you are using it would be a little easyer to help you.

[Desert Piranha]

Hi All

I wonder if any kind soul can help me......

I'm trying to automate putting column L to the far left (ie cant see cols A-K, but not wanting them hidden) and then putting Freezepane on at col M.

But everytime I code to move the activecell from say col B to AY, Col L disappears behind the row heading, or if then I select col L the screen then shows from col E?? Yet if I manually move the curser using the arrow keys I can get Col L to be the first left hand Col.

Many thanks

Badger

Hi,

Don't know if i understand correctly what you want but see if this is anywhere close:

Private Sub Worksheet_Activate()
ActiveWindow.ScrollColumn = Range("L1").Column
ActiveSheet.Range("M1").Select
ActiveWindow.FreezePanes = True
End Sub

Put it in the Sheet Module

[BadgerMK]

That works a treat Desert, ur a diamond thank you very much

Badger

[Desert Piranha]

That works a treat Desert, ur a diamond thank you very much

Badger

Hi Badger,

Glad it worked for you.