excel button

Question

Hi,

Sorry if I posted in wrong section. Before I going into my question, this are something I tried let say in Microsoft word contain macro with button that linked to the macro and save as template ("*.dot") as I can copy this file and deploy to other pc (on the pc I deploy I can see the button in Microsoft Word).

Now this my question can I do something the same in Microsoft Excel, I want the button appear on every pc I deploy? (between the excel I save as personal.xls)

http://office.microsoft.com/en-us/excel/HA010872961033.aspx (this the reasons why I use personal.xls - You keep personal.xls hidden unless you want to add macros to it. Whenever you start Excel, personal.xls opens automatically and runs in the background . If you don't hide the file, Excel opens it and allows you to add data to it.)

Thank You for and sorry for my poor English.

Regards,
MC

---

Mcafe

Answer 1

Hi McAfe

Assuming the button you were mentioning is the button on a command bar, you can do the same in Excel Workbook (Xls) or Excel Addin (XLA)

You can try creating the button when Excel addin is loaded. The button will be available in all PCs that have the addin

Cheers
Shasur

---

http://www.vbadud.blogspot.com

Answer 2

Hi Shasur,


I tried with the same thing on Excel Workbook and try copy the xls to other pc the button didn't appear. Can show me sample code or guide me around?

Thank You

Regards,
Mc

---

Mcafe

Answer 3

Hi

Can you check if the following link helps you


http://vbadud.blogspot.com/2009/07/how-to-create-new-menu-using-excel-vba.html

Cheers
Shasur

---

http://www.vbadud.blogspot.com