Debra Dalgleish has some notes how to implement macros he

I also add a link to Debra's page on my code page now in the more info part
http://www.rondebruin.nl/code.htm



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Gord Dibben" <gorddibbATshawDOTca wrote in message ...
See Dave's reply in addition this this one.

Another link for your perusal would be Ron de Bruin's site

Where to store code...............

http://www.rondebruin.nl/code.htm


Gord

On Sat, 28 Jun 2008 14:19:00 -0700, Tara wrote:

Thanks Gord
But I don't know how to use them? could you explain it to me?what should I
do with them?Thanks a lot.

"Gord Dibben" wrote:

Assign one of these to a button or shortcut key.

Sub addafter()
Worksheets.Add After:=Worksheets(Worksheets.Count)
End Sub

Sub addafter2()
Worksheets.Add After:=ActiveSheet
End Sub


Gord Dibben MS Excel MVP

On Sat, 28 Jun 2008 06:08:01 -0700, Tara wrote:

Thank you so much Martin.
I Konw that by drag and drop I can move my new sheet, but my teacher has
asked me why when we insert new sheet it goes to the right for example sheet
1 2 4 3
How can I insert a new sheet into the right of my old sheet? Do you know?
Thanks again.

"MartinW" wrote:

Hi Tara,

Regardless of where you insert the sheet, you can move sheet
tabs by simple click and drag on the tab. As you drag, a broad arrow
will show where it will be dropped once you let go of the
left button.

HTH
Martin


"Tara" wrote in message
...
Hello to all.Hope everybody are doing great.
I have a question in Excel 2003.How can I insert another sheet just next
to
the old sheet? for example I have sheet1 sheet 2 sheet 3 I want to insert
sheet 4 to the right of the sheet 3? How can I? because when I do this the
sheet will place to the left.Please help me.
I'm waiting for you.Thanks.