View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default How do I create buttons to link worksheets within a workbook?

Hi,

Click

View|Toolbars|forms
Click the button icon on the toolbar
Put the cursor over the worksheet where you want the button and drag the
button to the size you want
When you relaease the mouse button a dialogue will pop up
Click New
Enter the code
Sheets("Sheet2").select
click the red cross to close VB editor
Click your button

Mike



"kay505" wrote:

E.g. Creat a list of buttons/links on Sheet1 to take me directly to Sheet2.