The usual practice is to put public variables in a standard module. Public
variables in workbook or worksheet modules are not visible unless qualified
with their full name, for example:

Msgbox ThisWorkbook.MyVariable

--
Jim
"Daveh" wrote in message
...
|I have defined a variable Public As String in the Workbook_Open module, but
| it is not transferring to other procedures in different modules in the
same
| project.
|
| Any thoughts ?
|
|