Hi!
Try this:
1) Create a command button and name it as CommandButton1
2) Insert the following code in CommandButton1
Private Sub CommandButton1_Click()
Worksheets("Sheet1").Activate
End Sub
-----Original Message-----
Hi,
I would like to create an excel template with tabs at
the top. The
template should look like:
http://www.excelforum.com/newthread.php?
s=&action=newthread&forumid=7
Basically I am wanting to have tabs like Home, Excel
Books, Excel Tips,
My Tips etc and under each of this tab I will have many
buttons which
take users to different excel sheets. I know I can use
Worksheet tabs
for this purpose however those tabs remain at the bottom
instead of at
the top. Is this possible to do that in Excel. Please
let me know. Many
thanks in advance.
Kind regards
---
Message posted from http://www.ExcelForum.com/
.