Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Set Worksheet Names in a Module
Hi
Example: set wksCurrent = worksheets("Testing") set wksNew = worksheets("Antoher") as the same names can be used over each sheet instead of having to enter code in as Sheets("Testing").cmdTest.visible = true I was hoping to cut it down to be wkscurrent.cmdtest.visible = true Any help aprreciated. Thanks Noemi |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Set Worksheet Names in a Module
You could use:
wkscurrent.OLEObjects("CommandButton1").Visible = False Or you could use the CodeName (look at the properties of the worksheet when you're in the VBE) Sheet1.CommandButton1.visible = true Inside the VBE hit ctrl-r (to see the project explorer Click on the worksheet hit F4 to see the properties of that sheet the property called (Name) -- with the parentheses is the codename. You can type over that name to get something more meaningful, too. Maybe Testing??? then Testing.commandbutton1.visible = true would work Noemi wrote: Hi Example: set wksCurrent = worksheets("Testing") set wksNew = worksheets("Antoher") as the same names can be used over each sheet instead of having to enter code in as Sheets("Testing").cmdTest.visible = true I was hoping to cut it down to be wkscurrent.cmdtest.visible = true Any help aprreciated. Thanks Noemi -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to sort Worksheet names? | Excel Discussion (Misc queries) | |||
Duplicate Range Names by worksheet | Excel Discussion (Misc queries) | |||
Adding worksheet tab names to the first worksheet | Excel Discussion (Misc queries) | |||
Lookups using worksheet names | Excel Discussion (Misc queries) | |||
Worksheet names | Excel Worksheet Functions |