Hiya Forumittes :)

I have put some standard code in "Workbook_open".
The code uses a "Const" (Constant) set-up in (General)(Declarations).

---- Code in General Declarations ----

Const Library_Name = "library.xla"

---- End Code ----

---- Code in Workbook_open ----

Application.Run(Library_Name & "!make_toast")

---- End Code ----


...So far so good...

But i put a button in Sheet 1, that needs to use the same "Const". But
"Sheet1" cant see the "Const" value set in "ThisWorkBook".

---- Code in Sheet 1 ----

Private Sub Testing_Button_Click()

MsgBox(Library_name)

End Sub

---- End Code ----

* so in summary, is there a way to set a value in "ThisWorkBook", used
in "Workbook_open" and through buttons on "Sheet1..2..3". Im hoping
along the lines of a Global/Public Constant.

....Dont ya just love the curly ones... ;)

eXcellence