sykes
Well-known Member
- Joined
- May 1, 2002
- Messages
- 1,885
- Office Version
- 365
- Platform
- Windows
Can't find this in help anywhere............
I'm using Excel 2007.
Personal.xlsb is in the correct place.
When I try to call Personal.xlsb procedures from another workbook, I'm getting "Sub or function not defined."
The procedure I want to call is in a module in Personal.xlsb:
If I put a calling procedure in the same module within Personal.xlsb it works fine, so the integrity of the basic bit of code's tested:...
if I now try to call msg in the same way, but from a module in another workbook, I get the error.
Any ideas?
Sub tst()
msg ("Hurrah!")
End Sub
I'm using Excel 2007.
Personal.xlsb is in the correct place.
When I try to call Personal.xlsb procedures from another workbook, I'm getting "Sub or function not defined."
The procedure I want to call is in a module in Personal.xlsb:
Code:
Public Sub msg(mess As String)
MsgBox mess
End Sub
Code:
Sub tst()
msg ("Hurrah!")
End Su
if I now try to call msg in the same way, but from a module in another workbook, I get the error.
Any ideas?
Sub tst()
msg ("Hurrah!")
End Sub