I want to create buttons on a main sheet, such that clicking a button would take tyou to the appropriate worksheet.
Thanks for nay help.
modytrane
I want to create buttons on a main sheet, such that clicking a button would take tyou to the appropriate worksheet.
Thanks for nay help.
modytrane
Try using a button from the FORMS toolbar. When you place it on the sheet, the "Assign Macro" dialog will appear with the default macro name: ButtonX_Click.
Select RECORD
Click the tab of the sheet you want it to activate.
On the Menubar, click Tools -> Macro -> Stop Recording
Repeat for each new button.
Ben Van Johnson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks