Scope of Subs?
Hi Ken,
You can call a sub in the Thisworkbook module if the sub is declared
public.
For example:
In the ThisWorkbook module:
'-------------------------------
Public Sub Workbook_Open()
MsgBox "Hello from Workbook_Open!"
End Sub
In a standard module:
---------------------
Sub CallIt()
ThisWorkbook.Workbook_Open
End Sub
---
Regards,
Norman
"Ken Loomis" wrote in message
...
I am trying to call a sub in the workbook object from a sub in a module,
but I can't seem to make that work.
Is there a way to make that work?
TIA,
Ken
|