Set Worksheet Name
Hi
Is it possible to set the names of each worksheet in a module so I can refer
to it within the sheets itself.
ie
Set wksCurrent = worksheets("Sheet1")
set wksKey = worksheets("Sheet2")
etc
The above is what I would like to declare and have set in a module and then
in the worksheets i would use
wksCurrent.select
wksKey.visible = true
etc.
I am hoping that I dont need to keep adding the Set wksCurrent =
Worksheets("Sheet1") etc for each private or public sub.
|