Opening worksheet at the same cell and page every time

[piczim]

I would like to know if its possible to open a work sheet excel 2010 on the same page and same cell everytime you open the work book.

I have an Index sheet and would like the saved document to open on the index page every time I open it even if I have not saved the work book on the index page


Thanks

Rodney

[AndyLitch]

Adjust the sheet number and the cell location to the following code and put it in a code module in the VBE.

Please Login or Register  to view this content.

[martindwilson]

wouldnt that have to be in the workbook module ?

Please Login or Register  to view this content.

[HaHoBe]

Hi, Martin,

both Auto_Open and Auto_Close from the pre-97 area are still supported if found in standard/normal modules. Code gets fired after the Workkbook_Open-Event AFAIR.

Ciao,
Holger

[AndyLitch]

It works from a code module too ... I think it get's higher priority when in the workbook module but then i think there is also a workbook_open sub ..

[martindwilson]

yep i just tried it and agree with you all.

[piczim]

Sorry to Sound really stupid but how do I put this code into the VBE

[AndyLitch]

1. Right click on any worksheet tab
2. Select "View Code"
The VB editor window opens to display the associated VBA
3. Right click on the VBA project listed at the left which corresponds to your workbook name
4. Select Insert
5. Select Module

Then copy/paste the code into the module

To run the code you can either close/open the workbook or run the macro directly.

[piczim]

Thank you! This worked perfectly for me.

[piczim]

1. Right click on any worksheet tab
2. Select "View Code"
The VB editor window opens to display the associated VBA
3. Right click on the VBA project listed at the left which corresponds to your workbook name
4. Select Insert
5. Select Module

Then copy/paste the code into the module

To run the code you can either close/open the workbook or run the macro directly.

Sorry to be re visiting this but It suddenly stopped working. I added hyper links today and now where I save and close the workbook this is where it opens. I removed the module saved and closed and then re inserted with no change. Is there anything else I should check

[AndyLitch]

Check your Excel settings and make sure that macro's are enabled.
1. File --> Options --> Trust Center
2. Hit the "Trust Centre Settings" Button
3. Go to "Macro Settings" and adjust them to ensure they are allowed to run.

[piczim]

Thank you very much problem solved

[arlu1201]

I have marked the thread as solved for you as you will not be able to do it. Please mark your threads as solved in future.