Open to Worksheet

[KimR.Hammel]

I'd like an Excel Workbook to always open to a certain worksheet

Next, it should refresh the calculations upon opening.

It should also refresh the calculations upon activation of the sheet later

While open, it should run a routine everytime a value in a given cell changes

Thus, if they open the workbook, it goes to a particular worksheet,
refreshes calculations, and if a particular cell changes, it should perform a
routine

Is this too much to ask? Thanks in advance..

 

[Rowan Drummond]

It's not too much to ask but you will need to give more detail if you
want a more detailed answer.

You could use the Workbook_Open event to activate the specified
worksheet every time the book is opened or you could use the
Workbook_Activate event to activate the sheet every time the book is
selected.

Similarly you can use a Worksheet_Change event to run a routine every
time the value of a cell changes.

See http://cpearson.com/excel/events.htm for more on excel events.

Regards
Rowan