Call a sub statement in "Personal Macro Workbook" from "ThisWorkbo
 

I have a "Workbook_BeforeSave" procedure in a workbook and I want to call a
sub procedure from my personal macro workbook.

Is there a way to do this? Typically I would just use a call statement, but
I think I have to change the type of statement so that I can call it.

Call a sub statement in "Personal Macro Workbook" from "ThisWorkbo
 

application.Run "Personal.xls!Macro6"

--
Regards,
Tom Ogilvy


"QC Coug" wrote in message
...
I have a "Workbook_BeforeSave" procedure in a workbook and I want to call
a
sub procedure from my personal macro workbook.

Is there a way to do this? Typically I would just use a call statement,
but
I think I have to change the type of statement so that I can call it.