View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mato nanjin mato nanjin is offline
external usenet poster
 
Posts: 9
Default Another stupid newbie question.

I am trying to dim some variables as public. I have this statement (among
others) in a module in the Auto_Open Sub:

"Public dtPropDate As Date ' quote date"

I get the following error message when the workbook loads:

"Compile error. Invalid atribute in Sub or function"

Any ideas why I get this?

How can I screw up something this simple?

Thanks, Ron