Thread: Change Default Worksheet

How would you change the default worksheet that opens up when you add another sheet to the workbook?

By the way, I've seen some methods to do it on Windows but I am using Office for Mac 2011. Any help would be appreciated.

Thanks,

Chris

What do you "change". Change the title of the worksheet?

Hi,

Thanks for replying. I want to change the change the default worksheet from being full of blank cells to a template that I created. Hope this makes sense.

Chris

So, when a user opens Excel, it is your templated spreadsheet? Sorry if this seems difficult to explain, but default would be the action that automatically happens when Excel is opened. If you just want your templated worksheet to open, why not just open the entire workbook that contains the templated worksheet?
I just re-read your original query. I think you are trying to have a new sheet (Insert Worksheet) be templated, right?

Hi mhuston,

What I mean is that when I add another worksheet to an EXISTING workbook that I already have open, instead of a blank worksheet, a custom template comes up. I am not talking about opening up a new workbook. Sorry for not making this clear enough and thanks a lot for your patience.

Chris

Try this:

Private Sub Workbook_NewSheet(ByVal Sh As Object)
Application.EnableEvents = False
With Sh
Sheets.Add Type:= _
"C:\Documents and Settings\All Users\Templates\TimeCard1.xltx"
End With

End Sub

where your template is TimeCard1.xltx in the above.

Hi mhuston,

Thanks for the help but how exactly do you this? I have no idea how to use VBA, macros and other things like that. Also, I am on a Mac so the file location would be different.

Chris

Originally Posted by chrisexcel

Hi mhuston,

Thanks for the help but how exactly do you this? I have no idea how to use VBA, macros and other things like that. Also, I am on a Mac so the file location would be different.

Chris

Using VBA is rather simple, but beyond the scope of this answer. I would research Excel VBA.