Some more options...

Save the file as an add (*.xla). But don't use personal.xla as the file
name--if you do that, then you may collide with a user's own personal.xla file.
(Excel can only have one file open with that name.)

Save it to a network drive and mark it readonly (using windows explorer).
Have the users do:
tools|addins and browse to that location. I'd suggest that they use the UNC
path (instead of the Mapped drive) to locate the addin.

You'll have to give the users some way to access the subroutines. (Macros in
..xla's don't show up in the tools|macro|macros dialog.)

For additions to the worksheet menu bar, I really like the way John Walkenbach
does it in his menumaker workbook:
http://j-walk.com/ss/excel/tips/tip53.htm

Here's how I do it when I want a toolbar:
http://www.contextures.com/xlToolbar02.html
(from Debra Dalgleish's site)


Dave Peterson wrote:

Be careful with sharing files named personal.xls.

If any of the recipients have their own personal.xls file, then your file may
overwrite their files. And if they have important stuff in their files, you
could cause heart-ache and pain.

Instead close excel.
Find that personal.xls file (use windows start button|Search)
And name it something else (ChuckWUtils.xls)

Then either move that file (or copy that file) to the network share.

Tell your users to open that file whenever they need to use the macros.

ChuckW wrote:

Dave,

I checked the macro on the PC at it is called Personal.xls!Macro1. I think
it is stored in the Personal Macro Workbook. There are three other PCs on
the same domain that I want to have this run on. It would be possible to
move this to a common folder on the network if this is possble. Otherwise it
would be great if I could just copy this macro and move it to the local
drives of the other PCs.

Thanks,
--
Chuck W

"Dave Peterson" wrote:

I don't know if I can.

Macros can be created in any workbook. You may have recorded a macro and put it
in your personal.xls file. You could have recorded the macro in the workbook
that was active.

Can you share how you run it?

While you're looking at this, try to find clues that show where that macro
lives.

ChuckW wrote:

Dave,

I am a novice excel user. Can you give me more information on how to do
this? How do I find where the workbook that my macro is in is stored?

Thanks,
--
Chuck W

"Dave Peterson" wrote:

Macros live in workbooks.

So all you have to do is share the workbook with the other pc.

ChuckW wrote:

Hi,

I created a complex macro on a PC several months ago and am not sure exactly
what I did. I now need to move it to another PC. Is it possible to do this?

Thanks,

--
Chuck W

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson

--

Dave Peterson