Macro to take all tabs to cell A1

[sabunabu]

Before I save a file, I like to make sure that all the tabs are on cell A1. I usually do this by hitting Ctrl+Home on every tab. Can I write a macro that will do this for me? If so, how?


TIA!

[royUK]

Try

Please Login or Register  to view this content.

[chergh]

Please Login or Register  to view this content.

[Andy Pope]

This in the immediate window will do it.

Please Login or Register  to view this content.

Or this is you want to end up at the front sheet

Please Login or Register  to view this content.

[sabunabu]

That is awesome! Thank you. Is there any way I can set the macro to return to the top of a window that is frozen? For example, if I froze the pane at cell G3 on a certain tab, it would return the cell to G3 like Ctrl+Home does. I know I'm being picky here but I have a worksheet that has several tabs of which a few are frozen at certain cells.


TIA.

[royUK]

Try this

Please Login or Register  to view this content.