View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
DRKML DRKML is offline
external usenet poster
 
Posts: 3
Default Public Variable in ThisWorkbook

I want to declare some public variables as soon as I open the workbook. Can
I do that in "ThisWorkbook" or do I need to put it in a module and have
"ThisWorkbook" Open event call a routine to set the public variables?