Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Passing worksheet as an argument
Is there a way to pass a worksheet name as an argument? I want to
hide all of my worksheet tabs and i have created macro buttons to open the worksheets, but they have to be unhidden first. What I would like it to do is when I click the button.... unhide the worksheet i want to open, then show that one... then I would like to take that active sheet and brand it with oldSheet and then when they go back to main worksheet tab and click another button, to hide oldSheet and unhide the one they just clicked on and then show that one. The only way it seems logical to me is to pass the argument in each macro button, but it's not working. ANy Ideas as to where I'm going wrong? p.s. and would I have to make them all public sub to pass the info? -Marcus |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Passing worksheet as an argument
Sub HandleWS(byref ws as Worksheet)
With ws 'do stuff End With End Sub Sub DoSomething() Call HandleWS(ws:=Worksheets(1)) 'etc. End Sub and so on -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Marcusdmc" wrote in message ups.com... Is there a way to pass a worksheet name as an argument? I want to hide all of my worksheet tabs and i have created macro buttons to open the worksheets, but they have to be unhidden first. What I would like it to do is when I click the button.... unhide the worksheet i want to open, then show that one... then I would like to take that active sheet and brand it with oldSheet and then when they go back to main worksheet tab and click another button, to hide oldSheet and unhide the one they just clicked on and then show that one. The only way it seems logical to me is to pass the argument in each macro button, but it's not working. ANy Ideas as to where I'm going wrong? p.s. and would I have to make them all public sub to pass the info? -Marcus |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Passing worksheet as an argument | Excel Programming | |||
Passing a Control as an Argument | Excel Programming | |||
Passing a UDF as an argument to a UDF | Excel Discussion (Misc queries) | |||
Passing argument to another Sub | Excel Programming | |||
Passing Worksheet tab as an argument. | Excel Programming |