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

hi
i have written a function which i want to use
whereever i need to use in excel
how can i save such macro?
--
hemu
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,302
Default saving macro gloally

Hi Hemant,

If you save the function in your Personal.xls, it will be available to all
open workbooks.

Alternatively, save the function in an add-in.

See Jan Karel Pieterse's excellent tutorial at:

http://www.jkp-ads.com/Articles/DistributeMacro00.htm


---
Regards,
Norman



"Hemant_india" wrote in message
...
hi
i have written a function which i want to use
whereever i need to use in excel
how can i save such macro?
--
hemu



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
Macro For Saving As .txt jshendel Excel Discussion (Misc queries) 1 August 4th 08 08:18 PM
Saving with Macro mabbutt Excel Discussion (Misc queries) 2 May 11th 06 03:39 PM
Saving a spreadsheet without saving the Macro tedd13 Excel Programming 7 March 31st 06 02:17 PM
Macro for Saving!! toolroomman Excel Programming 1 February 22nd 06 09:21 PM
saving a macro hsg Excel Programming 3 December 16th 04 07:38 PM


All times are GMT +1. The time now is 05:33 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"