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.

"sammy" wrote in message
ond.com...
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.

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 Befo=Sheets(1)
End Sub


Gord Dibben MS Excel MVP

On Sat, 30 Apr 2011 00:23:37 +1000, "sammy" wrote:

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.

"sammy" wrote in message
pond.com...
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.