Hi Peter T.

Thank you this is a great solution, thak you for sharing!

And yes putting them in a workbook could be a solution but I actually intend
to put them in the code attached to Personal.xls. Then it will be always
available and not "pollutingly visible".

M.



Peter T wrote:
Most efficent way is to set a reference to the project containing the
constants and call them directly. However that's not always practical,
another way
......................
But why not put your constants in cells, eg

--
Message posted via http://www.officekb.com