View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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.