Returns to Sheet1 when I close my Spreadsheet?

[Antligen]

Hi,

I've designed a spreadsheet that has buttons and a contents page on sheet1.

What I would like to know is this:

Is there a way of making it so that everytime I open my spreadsheet, it automatically takes me to sheet1?
It would just make life a lot easier than to have to keep going back to sheet1 and saving!

Any help would be greatly appreciated!

Kind regards,

Antligen

[NickyC]

you could use an auto_open macro, but you will have to save your file as a macro enabled workbook

this takes you to cell B2 on sheet 1 every time the workbook opens:

Please Login or Register  to view this content.

[Antligen]

I opened Visual Basic a tried this but it did not work on my spreadsheet.

Antligen

[NickyC]

ok - the macro wont work if macros are disabled, or if you copied the code into the VBA area for a particular sheet, rather than a module attached to the workbook as a whole. Is either of these the problem?

[sktneer]

Open VBA Editor. On Project window on left pane, double click on ThisWorkbook and paste the code given below on the code window and save your workbook as Excel Macro Enabled Workbook.

Please Login or Register  to view this content.

Is this what you want?

[Antligen]

Perfect, works exactly how I wanted it to.

Thank you, much appreciated!

[sktneer]

Glad to help you. Thanks for the feedback and rep.
If that takes care of your question, please mark your thread as solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.