insert worksheet shift 11 tab

  • Thread starter Thread starter sammy
  • Start date Start date
S

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.
 
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.
Click to expand...
 
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
 
Back
Top