Positioning Inserted worksheets?

[garymu16]

How do I get excel to automatically put any inserted worksheets to the end instead of the start of the tabs?

 

[Smitty]

Welcome to the Board!

As far as I know you don't, but you can use a macro for a shortcut:

<font face=Tahoma><SPAN style="color:#00007F">Sub</SPAN> AddSheets()
    Sheets.Add After:=Sheets(Sheets.Count)
<SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN></FONT>

Hope that helps,

Smitty

 

[garymu16]

Thnx & Thnx