Most odd.
..OnAction = "BofQ Utilities.xla!Menu_Routines.AddBofQStandardPage"
results in a the same named sub being called from a completely different
project and module....
How can this be, please?
Regards.
"Tom Ogilvy" wrote in message
...
.OnAction = "MyWorkbookName.xls!Module1.AddBofQStandardPag e"
--
Regards,
Tom Ogilvy
Stuart wrote in message
...
Just to be sure, can one reference the module in that statement,
ie
.OnAction = "MyWorkbookName.xls! _Module1_AddBofQStandardPage"
Regards.
"Tom Ogilvy" wrote in message
...
.OnAction = "MyWorkbookName.xls!AddBofQStandardPage"
Assume you don't have two procedures with that name in that workbook.
If
the workbook isn't open, include the path.
--
Regards,
Tom Ogilvy
Stuart wrote in message
...
Am trying to direct a menu call to a specific Project and
Sub. The following attempt is not working:
With .Controls.Add(Type:=msoControlButton)
.Caption = "&Add a Standard Page"
.OnAction = "AddBofQStandardPage"
End With
More correctly, it is working, but is calling the sub
"AddBofQStandardPage" from a module in a different
Project.
How do I reference the sub in, say
Project1, Module1, when the the menu item is
triggered, please?
Regards.
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.520 / Virus Database: 318 - Release Date: 18/09/2003
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.521 / Virus Database: 319 - Release Date: 23/09/2003
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (
http://www.grisoft.com).
Version: 6.0.521 / Virus Database: 319 - Release Date: 23/09/2003