Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you move between tabs in Excel spreadsheet? | Excel Discussion (Misc queries) | |||
How do I add tabs at the bottom of my excel spreadsheet? | Setting up and Configuration of Excel | |||
how do i add tabs to an open excel spreadsheet? | Excel Discussion (Misc queries) | |||
how do I sort tabs on an excel spreadsheet | Excel Worksheet Functions | |||
how many tabs on a excel spreadsheet can you have? | Excel Worksheet Functions |