Further to Chip, it's not clear to me whether you're trying to use the
variable from code in another workbook, so...

Public means visible throughout a given VB project. Another project (aka
workbook) cannot see it unless it sets a reference to the workbook (Tools,
References).

--
Jim Rech
Excel MVP