Customer Button on Startup

[Edgar Thoemmes]

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


>-----Original Message-----
>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
>.
>