macro from desktop

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can I place the macro independent of worksheet? (from desktop) Every time to
run a macro I have to open a workbook (or) (it open automatically when
pressing macro
button) I reserved one workbook for recording macros only.
 
Lots of people do this kind of stuff by putting the macros in a workbook
(usually named personal.xls) and stored in Excel's StartUp folder.

Each time excel opens, it'll open this workbook, too. And all the macros will
be available.
 
Depending on what your macro does you can store it in a VBS file on
your desktop and execute that.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unwanted workbooks on startup 2
Run code from another workbook 7
How to call Excel add-in macro from a button… 1
Macro shortcuts are running macros in different open workbook 3
Macro for all Excel Workbooks to print to PDF 2
How to Unlock Excel Workbook protected by MACRO Password 6
Copy VBA code into a workbook created by a macro 11
Error Message - Macro to Unlink MS Queries from Workbook 0

Back
Top