Hello
I have a macro that when run with a Form button completes in about 5 seconds. If I run the same macro via an ActiveX button, it takes about a minute.
With the Form button I choose the macro to run through the menu. With the ActiveX I have Application.Run "ModuleName.MacroName"
Any idea why this would be?
Thanks
Last edited by Philb1; 09-07-2013 at 06:36 PM.
Hello Philb1,
There could be several causes but without seeing the code, I can't really say. Posting your workbook for review would be the best option.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Hi Leith.. I've tried calling the macro, using shapes & assigning the macro to them with no luck. Repair opened the file & found the file grew from 1.9mb to 2.2, not sure why that would be. Googled & found others have had the same problem & it seems like there's no fix. 2010 seems to be a bit of a problem child for MS.
I'll use the form button. The only reason I was going to use the ActiveX control was to pretty it up a bit.
I could understand it if I was running different macros, but the exact same code, the only difference being the button the command came from. Dunno
If you post the code then we can have a look, I'd be surprised if using an ActiveX button on a sheet really makes the difference, I suspect the issue is elsewhere. That said, it would be a cold day in hell before I'd put an ActiveX button on a sheet when there's a form alternative.
As an aside, 2010 is infinitely better than 2007 - that was horrendous
It's not a regular way to start a macro in an activeX contol using the Application.Run "ModuleName.MacroName" method.
Referring to the macromodule isn't either.
It appears that when you fully qualify every command and reference in the macro, the problem goes away. The other things I noticed are the workbook save time reduces by at least half & the file size shrunk.
All is well
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks