personal.xls ?

L

Lynxbci3

I have written several functions, and i am storing them locally withi
the required spreadsheet. I would like to be able to use them o
several different spreadsheets. I was pointed towards personal.xls. Bu
i can not find this. Where is it?

How would i make these functions available throughout the company (ove
400 users) on a server.

Thanks in advanc
 
J

JulieD

Hi

as to your first question - the easiest way i've found to get to
personal.xls (if you've never used it before) is to record a macro and when
you're naming the macro choose - "personal macro workbook" to save it in.
(the macro doesn't have to actually do anything - i just generally select a
cell and then stop recording).

once you've done this the code area of the personal macro workbook will be
visible when you right mouse click on a sheet tab & choose view code or when
you press Alt + F11.

i'm not sure what the best solution is for your second question but
hopefully others will have some ideas.

Regards
JulieD
 
D

Doug Kanter

I don't know about making functions available across a network, but do you
know how to start Windows Explorer and search for a file? If not, start
Explorer, hit F1, and take a look at the help file. I'm not trying to give
you a hard time, but it's a very basic thing you should know.
 
G

Gord Dibben

Doug

Another basic thing to know is that Personal.xls is not created until/unless a
macro is recorded and saved in the Personal Macro Workbook.

Search your computer all day and you will not find Personal.xls if the above
condition is not met.

Gord Dibben Excel MVP

I don't know about making functions available across a network, but do you
know how to start Windows Explorer and search for a file? If not, start
Explorer, hit F1, and take a look at the help file. I'm not trying to give
you a hard time, but it's a very basic thing you should know.
Click to expand...
 
G

Gord Dibben

Julie has posted how to create a Personal.xls

As far as the distribution across a server, I would save a workbook with
macros as an Add-in(*.xla) and place that in a common folder for all users to
access.

Gord Dibben Excel MVP
 
D

Doug Kanter

I didn't know that!

Gord Dibben said:
Doug

Another basic thing to know is that Personal.xls is not created until/unless a
macro is recorded and saved in the Personal Macro Workbook.

Search your computer all day and you will not find Personal.xls if the above
condition is not met.

Gord Dibben Excel MVP
Click to expand...
 
G

Gord Dibben

Doug

It is a frequent question.

Users are led to believe that Personal.xls is a default workbook that is
installed with Excel or Office.

Gord

I didn't know that!
Click to expand...
 
Top