Forgot How To Set Default Sheet

**AccountNameHere** · 09-01-2013, 12:38 AM

I had set up a long time ago a macro enabled sheet in the XLSTART folder and Template folder. It used to work where any file I opened, if I clicked new sheet, the data from that file would be in sheet2. Now for some reason it's not showing up anymore and just a blank sheet appears.

What am I missing here?

**alansidman** · 09-01-2013, 04:50 AM

Is this perhaps what you are looking for?

http://office.microsoft.com/en-us/ex...005200889.aspx

**AccountNameHere** · 09-01-2013, 01:19 PM

I did that already. Still doesnt work. I googled for over an hour and for some reason it still doesn't work. I even tried a system restore.

I need it to pre-load data every time I click new sheet at the bottom of the current sheet.