Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 43
Default macro from desktop

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default macro from desktop

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 236
Default macro from desktop

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
EXCEL FILES SAVED TO DESKTOP WILL NOT OPEN FROM DESKTOP randy111 Excel Discussion (Misc queries) 3 January 13th 08 10:38 PM
Macro - Save file in Desktop Dileep Chandran Excel Worksheet Functions 2 December 1st 06 08:37 AM
Use a macro to create a desktop shortcut? [email protected] Excel Programming 2 March 1st 06 11:28 PM
make macro run on someone else's desktop dnatoday Excel Programming 1 December 5th 05 03:52 PM
Executing a Macro From a Desktop Icon SidBord Excel Programming 1 April 25th 04 07:19 AM


All times are GMT +1. The time now is 09:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"