Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. ezil wrote: 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. -- Dave Peterson |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Depending on what your macro does you can store it in a VBS file on
your desktop and execute that. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
EXCEL FILES SAVED TO DESKTOP WILL NOT OPEN FROM DESKTOP | Excel Discussion (Misc queries) | |||
Macro - Save file in Desktop | Excel Worksheet Functions | |||
Use a macro to create a desktop shortcut? | Excel Programming | |||
make macro run on someone else's desktop | Excel Programming | |||
Executing a Macro From a Desktop Icon | Excel Programming |