Getting the Title Sheet to Appear 1st when Workbook is Opened

[without_sanity]

Hi

I want the title sheet to always be the 1st sheet that appears when an workbook is opened. I am creating a workbook that will be used by various people & saved on different pages. What I want is for it to always open on the Front Page (titled area select) regardless of what sheet the last save was made on. It's not a password protected workbook.

Thanks

[teylyn]

Hello without_sanity,

welcome to the forum.

You need a macro to do this. One possiblity is this:

Right click on a sheet tab, select View Code. In the VB Editor, double click the ThisWorkbook module in the navigation on the left. Copy the following code:

Please Login or Register  to view this content.

Change "Sheet1" to whatever your Front Page sheet is called.

Save the file as a macro enabled file, with the xlsm extension. Note that all users must have macros enabled for this to work.

cheers

[without_sanity]

Morning & thanks, never used a forum before but thinkn I will be in future.

It's worked, thanks very much. I knew it was something similiar to that but was doing it in the wrong place.

Have a good day