Cannot share makros with other users - Error Message with personl.xls

  • Thread starter Thread starter Petra Frimpong
  • Start date Start date
P

Petra Frimpong

I have created an excel makro which I saved in my
personl.xls. The makro was assigned to the menu.
Now I want to share this makro with other users. So I
copied the my personl.xls and excel.xlb and inserted the
files in the respective folders of the another user.
When this user starts Excel and wants to run the makro
from the menu the user gets the error message that
personl.xls is already open. However, the user can run the
makro from the tools menu. How can I solve this problem?
 
--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Petra,

It is probably pointing back to the original workbook. Just go in and change
all of the macro references.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Distribute Personl.xls and excel.xlb for net use 2
Editing options disapear when document is changed to compatibility 4
using environment variable in macropath 5
Getting rid of macro 2
using environment variable in macro path 1
Makro in Excel 4
Sub or Function not defined 3
Allow macro to work for a group of cells but not the other cells 7

Back
Top