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