You can also call it Global, works the same as Public, maybe more
informative.

--
__________________________________
HTH

Bob

"Rick Rothstein" wrote in message
...
To make the variable global to the entire workbook, declare it as Public
in the variable as Public in the (General)(Declarations) section of any
normal (BAS) Module. If you don't have any modules in your project, click
Insert/Module on the VB editor's Menu Bar and use that one. Here is an
example of what a declaration would look like (in this case, for a String
variable, but any valid data type may be specified)...

Public MyGlobalVariable As String

--
Rick (MVP - Excel)


"dhstein" wrote in message
...
How can I define a global variable that is accessible to any subroutine
in
any module of the workbook? Thanks for any help on this.