I'm looking to overwrite the 'Blank Workbook' within Excel 2007 with a template that I've created. I've created this default template within the C:\Program Files which opens whenever I open a new workbook or if I use Ctrl N.
However, when I go to File > New, i still have the option to select the 'Blank Workbook' which gets rid of all the formatting etc that I defaulted in. How can I remove the option to select 'Blank Workbook'? I only want to be able to open the template I created.
I'm pretty sure you used to be able to do this with previous versions of Excel because I seem to remember doing this in the past.
Preferably i'd like the solution to be macro free
Thanks
Sanya
Bookmarks