Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Buttons to link to a hidden sheet
Hi I have a hidden datasheet on Excel. I want a top sheet that links to this hidden sheet with buttons. When a button on the top sheet is clicked, the hidden sheet automatically updates. So for example a button on the top sheet is 'Number of queries' and someone clicks it once, the hidden page will have a 'total number of queries' that updates when the button on the top sheet is clicked. Does anyone know how to do this?? Thanks Tilly -- tillytee1 ------------------------------------------------------------------------ tillytee1's Profile: http://www.excelforum.com/member.php...o&userid=27688 View this thread: http://www.excelforum.com/showthread...hreadid=472028 |
#2
|
|||
|
|||
Hi Tilly, when you draw you button on the top sheet it asks you to assing a macro, like "Button1_click", click NEW In the VBA editor window that thn open copy in the following: Code: -------------------- Worksheets("Sheet2").Range("B1").Value = _ Worksheets("Sheet2").Range("B1").Value + 1 -------------------- You will need to replace "Sheet2" with the name of your hidden sheet. You will also need to replace "B1" with the cell address of the cell you want the count. HTH Art -- HiArt ------------------------------------------------------------------------ HiArt's Profile: http://www.excelforum.com/member.php...o&userid=19953 View this thread: http://www.excelforum.com/showthread...hreadid=472028 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
AUTO FILTER NOT CHANGING RESULTS | Excel Discussion (Misc queries) | |||
Hid rows in a hidden sheet. | Excel Discussion (Misc queries) | |||
Sheet hidden and VeryHidden | Excel Discussion (Misc queries) | |||
Use userform to get input and compare to a hidden sheet | Excel Discussion (Misc queries) | |||
Linking to an Entire Sheet | Links and Linking in Excel |