Excel 2007 Link worksheets with button

Microsoft Excel 2007
February 5, 2010 at 12:09:09
Specs: Windows Vista, EXCEL
I wanted to know about how to link worksheets using a button. I have made all the buttons and all the sheets. I just need to know how to link the buttons and the sheets together. I have tried assigning macros but it doesn't work properly. When I click run macro,I DON'T KNOW WHAT TO DO TO MAKE THE LINKS BETWEEN SHEETS.

See More: Excel 2007 Link worksheets with button

Report •

February 5, 2010 at 14:15:43

You haven't said anything about what you are trying to link to what.

For example
If you have two worksheets in one workbook, Sheet1 and Sheet2:

If you have "Help" in cell A1 on Sheet2
and then put this formula in cell A1 on Sheet1,


Cell A1 on sheet 1 will show "Help"
There is now a link between the worksheets.
Change the word Help in cell A1 on Sheet2 to the number 911 and cell A1 on Sheet 1 will show 911

or are you trying to do something entirely different!


Report •
Related Solutions

Ask Question