Macro Name
Macro Name
(OP)
When I go to to tools macros, some of my macros are listed by macro_name only and others are 'filename'!macro_name.macro_name. How do I get them to be listed by macro_name only?
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS Come Join Us!Are you an
Engineering professional? Join Eng-Tips Forums!
*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting Guidelines |
|
Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.
Here's Why Members Love Eng-Tips Forums:
Register now while it's still free!
Already a member? Close this window and log in.
RE: Macro Name
RE: Macro Name
ControlApp
'Data Collection.xls'!DelDup.DelDup
'Data Collection.xls'!Match.Match
Start1
Start2
These macros are all in the same workbook. I don't know why the macro name is repeated either.
When I choose 'all open workbooks' I see the ones in 'Personal.xls' and they look like:
'PERSONAL.XLS'!Remove
The macro name isn't repeated.
RE: Macro Name
Good luck.
Cheers,
Joerd
Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.
RE: Macro Name
You did give me a easy way to get rid of it. I'll just create new modules and block copy the code there. It's not as easy as editing the name but it will do and isn't a major hassle.
I thank you and so does the poor sap who will have to take over my stuff after I leave.