| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Numbers won't sort correctly. | Excel Discussion (Misc queries) | |||
| Extract icon from *.exe | Excel Discussion (Misc queries) | |||
| Add a close icon to Excel's Toolbar | Excel Discussion (Misc queries) | |||
| *.csv file wont load correctly | Excel Discussion (Misc queries) | |||
| Cant add an icon to toolbars | Excel Discussion (Misc queries) | |||
Hybrid Mode
