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
|