insert worksheet shift 11 tab

[sammy]

I have about 50 worksheets in one workbook I'd like to use the insert
worksheet tab with using control keys but I don't want to go to the extreme
right hand end of my screen to add a new worksheet by mouse click.
I'd like to move the ( insert worksheet shift 11 tab ) to the left hand end
of the open xcell window first and keep it there .

Appreciate your advice.

 

[sammy]

slight up date to my english

I have about 50 worksheets in one workbook I'd like to use the insert
worksheet tab with WITHOUT using control keys but I don't want to go to
the extreme RIGHT hand end of my screen to add a new worksheet by mouse
click.
I'd like to move the ( insert worksheet shift 11 tab ) to the LEFT hand
end of the open xcell window first and keep it there.

 

[Gord Dibben]

You want to insert a new sheet always at left side..........first sheet in
workbook using SHIFT + F11?

You don't want to use mouse to hit left sheet navigation arrow to move to
current left-most sheet before inserting new sheet?

Assign this macro to any shortcut key combo that you like.

Sub Add_Sheet_Left()
Sheets.Add Before:=Sheets(1)
End Sub


Gord Dibben MS Excel MVP