View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Noemi Noemi is offline
external usenet poster
 
Posts: 74
Default 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.