Thread: Macro Buttons
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default Macro Buttons

Yes you can. You need to create a Add-In (.xla) which populates a button or a
menu.

http://www.fontstuff.com/VBA/vbatut03.htm

If this post helps click Yes
---------------
Jacob Skaria


"Lois" wrote:

I have created a custom tool bar but it is only available on the one
workbook. Is there any way i can make it available to every new excel
workbook?
--
Lois


"Jacob Skaria" wrote:

Yes. Please refer
http://www.mvps.org/dmcritchie/excel/toolbars.htm

If this post helps click Yes
---------------
Jacob Skaria


"Lois" wrote:

Hi
Is there any way a macro can be assigned to a new button on the toolbar?
--
Lois