Public declarations are made in the declarations section of a module - which
is at the top (see the left dropdown at the top of the module).

In General:
If you want the variable visible to all components of the project, then you
need to declare it in a general module (insert=Module). Don't declare it
in any of the Class modules like ThisWorkbook, Sheet Modules or Userform
modules.

--
Regards,
Tom Ogilvy


Squid wrote in message
news:awqXb.33427$yE5.114887@attbi_s54...
Can I dim a public variable anywhere in a project or does it have to be in
a
module?

I have a variable in my workbook_open event. I now need to use this
variable elsewhere in my project. What is the proper way to do this?