Assigning Specific Cell on opening of workbook

[Johnmus]

Hi All,

I am using the following code to set freezepanes in Excel 2007 and then return to the current cell after exit and then return to the worksheet

Please Login or Register  to view this content.

However, when I close the workbook and reopen I want to go back to the top of certain sheets in the workbook (mostly C4) and in "ThisWorkBook" I am using the following to accomplish this:

Please Login or Register  to view this content.

I wonder if there is a better way to accomplish this?

Thanks

[vlady]

Hello
i'm not good at vba but maybe like this...

Please Login or Register  to view this content.

[TMS]

@vlady: that's neat but you need to select a single sheet at the end or it will leave the sheets grouped.

Regards, TMS