Creating Global excel macros
 

Hi,
I need to create a macro which could be used for all excel sheets.
Is this possible.
Thanks..

--
Message posted from http://www.ExcelForum.com

Creating Global excel macros
 

Yes, it is possible, just place it in personal.xls as a module and it will
be visible from all of the worksheets.
Tomek

"Sebastian_var " wrote in
message ...
Hi,
I need to create a macro which could be used for all excel sheets.
Is this possible.
Thanks...


---
Message posted from http://www.ExcelForum.com/

Creating Global excel macros
 

If you want to run it from VBA, the format is

Application.Run "'Personal.xls'!Test"

If the macro has arguments, you use

Application.Run "'Personal.xls'!Test", "Goodbye"


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Tomek" wrote in message
...
Yes, it is possible, just place it in personal.xls as a module and it will
be visible from all of the worksheets.
Tomek

"Sebastian_var " wrote in
message ...
Hi,
I need to create a macro which could be used for all excel sheets.
Is this possible.
Thanks...


---
Message posted from http://www.ExcelForum.com/

Creating Global excel macros
 

Sebastian

In addition to storing in the Personal.xls workbook, make sure the code does
not refer to hard-coded items such as worksheet names, workbook names, cell
references etc.

Use relative references as Offset, Activecell, Activesheet.

If recording the macros, toggle the "Relative Reference" button to "ON"

Gord Dibben Excel MVP

On Tue, 10 Feb 2004 05:01:38 -0600, Sebastian_var
wrote:

Hi,
I need to create a macro which could be used for all excel sheets.
Is this possible.
Thanks...


---
Message posted from http://www.ExcelForum.com/