Marcster
02-08-2006, 05:51 AM
RE: http://vbaexpress.com/forum/showthread.php?t=7008
How do you pass arguments to the macro?
I've tried:
Run ("PERSONAL.XLS!RemoveAllVBACode(wb)")
Run ("PERSONAL.XLS!RemoveAllVBACode wb")
None work.
Set wb = ActiveWorkbook
The modue name in PERSONAL.XLS is:
ModRemoveAllVBACode
Thanks,
Marcster.
How do you pass arguments to the macro?
I've tried:
Run ("PERSONAL.XLS!RemoveAllVBACode(wb)")
Run ("PERSONAL.XLS!RemoveAllVBACode wb")
None work.
Set wb = ActiveWorkbook
The modue name in PERSONAL.XLS is:
ModRemoveAllVBACode
Thanks,
Marcster.