command bar in excel window (office xp windowsxp)

Topic

New Reply

having found numerous examples on the web with a command bar on the window i am at a loss on how to proceed in placing it there all i want to do is run a macro from it.

Reply | Quote

Replies

Hi Alexanderd

For examples of how to create command bars check the following.
http://j-walk.com/ss/excel/tips/commandbars.htm%5B/url%5D
http://www.cpearson.com/excel/menus.htm%5B/url%5D

Reply | Quote

thank you for your quick responses looking forward to try them out.

i will get back to you once i have tried them

Reply | Quote

thank you for your quick responses looking forward to try them out.

i will get back to you once i have tried them

Reply | Quote

Hi Alexanderd

For examples of how to create command bars check the following.
http://j-walk.com/ss/excel/tips/commandbars.htm%5B/url%5D
http://www.cpearson.com/excel/menus.htm%5B/url%5D

Reply | Quote

If you just want a macro button, you can use the command button from the forms toolbar and add it to your worksheet.

If you want a new toolbar button to run the macro (available to all workbooks) you can go t:
View – toolbars – customize..
Commands (tab)
Categories: Macro
Commands: Custom Button
You can assign the macro here and change the image.

Steve

Reply | Quote