opening a workbook on a set worksheet

[foilprint0]

Hi

Wondered if it is possible to set the first workshhet in a workbook as the opening page every time the workbook is opened, rather than the last worksheet viewed.

 

[xlbo]

the worksheet in view will ALWAYS be the last one selected when it was last saved - you can use code in the workbook_open event to set the page but AFAIK, there is no setting to do this

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244