Saving the Macro for all workbooks

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have a code which I have wrtitten seperately which now I to be accessible
by all workbooks, I have heard that there is a hidden file where we can save
this, but I am not able to find it, can anyone please guide me how to go
about it.
 
Personal.xls.

Personal.xls is located in the XLStart directory, and is used to store
macros and
things that you want to be available to all workbooks, whenever you start
Excel.

By default, it is hidden in Excel, but if you go to the VBE, you use it as
you can
with any other open workbook (you don't have to unhide it).

You can create it by
- goto Tools>Macros>Record New Macro...
- Choose Personal Macro Workbook form the dropdown
- OK
- click the Stop button on the toolbar that pops-up

You now have a Personal.xls workbook. It is not visible though, it is hidden
by default (Windows>Unhide)


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Hi Bob,

Thanks for the replying back. I was able to find the Personal.xls file and i
had added the code in the module also but when i tried to use it some other
workbook it didn't worked.

Can you please help me out how to go about it.
--
Regards,
Pranay Shah


Bob Phillips said:
Personal.xls.

Personal.xls is located in the XLStart directory, and is used to store
macros and
things that you want to be available to all workbooks, whenever you start
Excel.

By default, it is hidden in Excel, but if you go to the VBE, you use it as
you can
with any other open workbook (you don't have to unhide it).

You can create it by
- goto Tools>Macros>Record New Macro...
- Choose Personal Macro Workbook form the dropdown
- OK
- click the Stop button on the toolbar that pops-up

You now have a Personal.xls workbook. It is not visible though, it is hidden
by default (Windows>Unhide)


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
Click to expand...
 
If you want to use a macro in another workbook, you need Application.Run

Application.Run "Personal.xls!test_macro"

.... with parameters

Application.Run "Personal.xls!test_macro", 4, 8

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

Pranay Shah said:
Hi Bob,

Thanks for the replying back. I was able to find the Personal.xls file and
i
had added the code in the module also but when i tried to use it some
other
workbook it didn't worked.

Can you please help me out how to go about it.
Click to expand...
 
Hi Bob,

How do I use the Application.Run and where do i add this in my workbook?
Sorry, I new to this field so please bear with me. :)

Thanks.
 
where you are currently trying to call the macro

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
If you're trying to use a function that you created and stored in personal.xls
in a cell in a worksheet, you'd use something like:

=personal.xls!yourfunctionnamehere(...)



Pranay said:
Hi Bob,

Thanks for the replying back. I was able to find the Personal.xls file and i
had added the code in the module also but when i tried to use it some other
workbook it didn't worked.

Can you please help me out how to go about it.
Click to expand...
 
Pranay

Create an Add-in with your macros.

Then load the add-in through Tools>Add-ins.

You won't have to use the Personal.xls! or Application.Run method


Gord Dibben MS Excel MVP
 
Ok so I'm confused and very new to macros. I am trying to have a previous macro that I created, be able to go to all future worksheets in this particular folder. How do i complete this? My second problem is I have a folder with tons of excel worksheets and I want make a macro for when i am in one worksheet, i can jump to another quickly without scrolling in the folder to find it. Is this possible??
 
Back
Top