Don't declare it within the Workbook_Open module.

Best place to put global/public variables and constants is in the
Declarations section of a regular code module. It will be accessible to all
modules from there, including within your Workbook_Open() event processor.

If you actually coded it as
Public As String
then Excel thinks it is a variable named 'Public' that is used within the
Workbook_Open() code segment.

Public myVariable As String
would be the way it should be entered (outside of a sub or function; i.e. in
the declarations section).

"Daveh" wrote:

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 ?