Macors do not run correctly from icon

T

TonyL

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
 
R

Ron de Bruin

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
 
R

Ron de Bruin

I see "icon on the toolbar" now

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

activecell.activate
 
Top