Custom Freez Pane

Hi, waqarqrl,

maybe use this macro recorder code for the action on the active sheet:

Please Login or Register  to view this content.

Ciao,
Holger

Put the cursor in cell H3, then select freeze panes from View tab on the ribbon, then select Freeze Panes

Hi, waqarqrl,

your workbook does not correspond to your opeing post (....colomn A to G should Freez, in workbook Columns A to H are coloured yellow).

The code I supplied is the full code which runs fine in any version of Windows Excel from 97 to 2010 on the active sheet except for one change for your workbook where Range should be I3 instead of H3 (I posted this version due to the ease of understanding: just enter the cell and call the ActiveWindow.FreezePanes = True line).

Ciao,
Holger

Hi, waqarqrl,

youīre not able to insert a Module into a workbook and donīt know how to get the code sniplet into a procedure?

Sheet1 is your sample, macro is assigned to a shortcut (CTRL + Shift + z), in Sheet2 you just need to right click in a cell to freeze pane there.

Maybe you should attach a macro-enabled workbook next time you want some VBA-Code inserted...

Ciao,
Holger

Hi, waqarqrl,

and i apologized if u feel any inconvienance

You need not apologize - itīs for me and the explanations to be given (not just the line of code but some words for that as well).

If you have set the FreezePanes to a sheet and you want to alter the position you will first need to disable this setting, then set a new cell and run the command again. The example how to proceed may be found behind the Sheet2 but for the normal code it may look something like this:

Please Login or Register  to view this content.

although I would split up the code into 2 procedures like

Please Login or Register  to view this content.

so that the UnFreeze may be called on itīs own.

Ciao,
Holger