Tabs in Excel Spreadsheet
 

Hi,
I would like to create an excel template with tabs at the top. Th
template should look like:

http://www.excelforum.com/newthread....read&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 whic
take users to different excel sheets. I know I can use Worksheet tab
for this purpose however those tabs remain at the bottom instead of a
the top. Is this possible to do that in Excel. Please let me know. Man
thanks in advance.

Kind regard

--
Message posted from http://www.ExcelForum.com

Tabs in Excel Spreadsheet
 

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/

.