Macro Personal Folder

  • Thread starter Thread starter Rebecca
  • Start date Start date
R

Rebecca

When working with macros, I created a personal folder, now
it follows me everywhere. I created a small data base for
someone at work, however my personal macro would not allow
him to make changes to his document I sent him. How do I
get rid of the personal.xls ?
 
Rebecca

I don't know but I'd try saving a copy of the file with a
new name in the My Documents folder and give this to your
colleage.

Regards
Peter
 
Your personal workbok is just that YOURS. You have an
option of where to store the macro 1) in the current book
so it is available only in that book by any user or 2)in
your personal book which allows you to use the macro in
any book you have.
You can export or copy the module to the original book.
Launch the VBA editor and see help for directions
good luck
 
Rebecca

Personal.xls is a file created to store macros that are available to all
workbooks.

It is placed in your XLSTART folder on your computer and opens with Excel.

If you send a workbook to another person and do not also send that person a
copy of your Personal.xls, that person will not have those macros available.

If there are macros in the database file you sent, they are in that file, not
your Personal.xls file.

I would look for code in the database file.

With that file open, hit ALT + F11 to access the Visual Basic Editor. Look
for "Modules" in the workbook/project. Are there any? If so, do they contain
the macros you thought were in Personal.xls?

You can, if you wish, right-click on a module and "Remove Module". Answer NO
to "Export".

Post back with more details if need more help with this.

Gord Dibben XL2002
 
Back
Top