PUTTING EXCEL MACRO ON DESKTOP

  • Thread starter Thread starter Brian Quigley
  • Start date Start date
B

Brian Quigley

Can anyone help me with the following,
i have created a button and attached a macro to it in an
excel worksheet but i want to place the button on my
desktop, can this be done and how is it done.
Kindest Regards
Brian Quigley
 
You could create a shortcut on the desktop that points to the workbook, but I
think that's as close as you can get.

If that's ok, just rightclick on an empty spot on the desktop and select
New|shortcut, browse for your .xls file.

If you wanted that macro to run whenever that workbook is opened, name it
Auto_open (in a General module) or put it in Thisworkbook as workbook_open.
 
I have a test workbook that contains the macro needed on many
workbooks. I always open that workbook when I use that particular
macro on other workbooks.

I think I'll add a button to the MS Office Bar that opens that
spreadsheet...saves me a few steps... Thanks for your tip.


Tippy
 
Simply create a shortcut to the file. Right-click on a blank area on the
desktop and New>Shortcut>Browse of the file>*follow the wizard*
 
Back
Top