Macors do not run correctly from icon

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a macro & it runs fine when activated from the macros list. I
have applied the macro as an icon on the toolbar but the macro does not run
correctly from the icon. It only completes about half of the code. Why is
this? Thanks

Tony
 
Hi Tony

If you use Excel 97 then

Try to Change the takefocusonclick property to false of the button
This is a bug in Excel 97
 
I see "icon on the toolbar" now

Try to add this line to the macro(first line)

activecell.activate
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem (bug?) in the way Excel 2007 doesn't automatically load ma 8
Error After Copying Excel 2003 Macros and Toolbars from Windows Vistato Windows 7 1
How to call module function or sub from the Add In? 3
Assigning Macros to Toolbar buttons 1
i need to find the exact location of macro to paste in the existing macro need to get the out put co 0
Pasting cell contents into a macro 1
Excel 2007: Help creating a macro that will run Solver? 3
copy 2007 created macro to run in 2003 4

Back
Top