Tabs in Excel Spreadsheet

H

hannah

Hi,
I would like to create an excel template with tabs at the top. Th
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 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
 
P

Poh

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy tab from one spreadsheet to multiple tabs in another spreadsheetwhile retaining the targets spr 15
Running a Check prior to crating tabs. 2
My top tabs (file,edit, etc) are missing in Excel. Help 1
Exporting selected tabs multiple times to different file names 1
How do I enter unique row ID's in multiple tabs in Excell? 1
Hiding the Insert New Worksheet tab in Excel 2007 3
Copying tabs in a workbook 6
Excel Work"Book" Tabs anyone? 3

Top