|
Macors do not run correctly from icon
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 -- Regards Ron de Bruin http://www.rondebruin.nl "TonyL" wrote in message ... 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 |
I see "icon on the toolbar" now
Try to add this line to the macro(first line) activecell.activate -- Regards Ron de Bruin http://www.rondebruin.nl "Ron de Bruin" wrote in message ... 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 -- Regards Ron de Bruin http://www.rondebruin.nl "TonyL" wrote in message ... 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 |
| All times are GMT +1. The time now is 08:30 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com