Freez Panes Automatically

[ANDRE LE ROUX]

Hi
Can Excel 2010 be set to automatically freeze panes and add filters to top row, when opening a new workbook or sheet???

[Richard Buttrey]

Hi,

Yes of course. Just use the appropriate event.

i.e. If by 'new workbook' you mean want this functionality when the workbook itself is opened for the first time, use the Workbook_Open event, or if you're creating a new workbook for the first time from a macro in another workbook, add the code below to the macro.
The same goes for a 'new sheet'. If in the current workbook use either the sheet Activate event if the sheet exists , or if it is a new sheet added to the workbook use the .Add syntax or if copying a sheet the Sheets("Sheet1").CopyBefore:="Sheet1_Copy") syntax.

Wherever you put the code first have the macro select the sheet and cell which you want to freeze and use this to freeze the panes

Please Login or Register  to view this content.

and for the filter

Please Login or Register  to view this content.