simple question about macros
 

Hi

I' ve got few macros binded to one excell file. Problem is that i want to
make them visible for all other excell sheets on my computer. Is there a way
to do this? Maybe there is a directory I must copy my macros into or
something else must be done...

thanks for any reply

Marcin

simple question about macros
 

Create an addin. Here are some articles on it


Building Application Specific Add-Ins
http://msdn.microsoft.com/library/de...ificaddins.asp

Excel Add-Ins
http://msdn.microsoft.com/library/de...xceladdins.asp

Add-ins, Templates, Wizards, and Libraries
http://msdn.microsoft.com/library/de...slibraries.asp

--

HTH

RP
(remove nothere from the email address if mailing direct)


"mati" wrote in message
...
Hi

I' ve got few macros binded to one excell file. Problem is that i want to
make them visible for all other excell sheets on my computer. Is there a
way
to do this? Maybe there is a directory I must copy my macros into or
something else must be done...

thanks for any reply

Marcin

simple question about macros
 

Marcin

Copy the macros you have to your "Personal.xls" workbook. This file
finds itself in the "XLStart" folder.

The files in this folder open every time you start Excel, thus making
your macros available during your session. (It's usually hidden from
view so you don't know it's open).

Regards

Mohsen

simple question about macros
 

The workbook with the macros should be open in Excel at the same time as the
other workbooks. Excel provides for this by using a workbook named
personal.xls. This is located in the xlstart directory and any file placed
there is automatically opened by excel when excel opens. It is also hidden
(window=Hide). You could also just locate your current workbook in the
Excel Start and optionally hide it if you want.

In any event, the public macros for any open workbook are visible in
Tools=macros=Macro

--
Regards,
Tom Ogilvy

"mati" wrote in message
...
Hi

I' ve got few macros binded to one excell file. Problem is that i want to
make them visible for all other excell sheets on my computer. Is there a
way
to do this? Maybe there is a directory I must copy my macros into or
something else must be done...

thanks for any reply

Marcin