Customer Button on Startup

[Guest]

Hi

How could I add some code to the workbook_open event of my personal.xls file
to add a customer button to the tool bar and assign a macro to it.

I have tried doing this manually but everytime I shut down excel and restart
the button has dissapeared (prob due to our over zealous IT dept)

TIA

 

[Markus Scheible]

Hi Edgar,

this is a typical question to solve with the excel macro
recorder... simply record it as a macro once when you do
it and copy it to Workbook_Open()

Best

Markus