Problem running macro from add-in (xla-file) in a shared workbook.

K

Klaus Trampedach

Hi,

I have a problem when running my macros in a self-made add-in
("thatname.xla")from a workbook I shared.

It works perfectly well before I share the file, all macros load when
I start Excel(2002). But as soon as I share the workbook, the macros
works fine for the first user (myself...) but all other users simply
just get the message that "a macro with thatname is already open".

I'm aware that there are several limitations in using shared
workbooks, but this problem doesn't seem to be one of them.

Does anybody now how to solve this problem or where I can find a
workaround?

Best regards
Klaus Trampedach
 

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

Run code from another workbook 7
Sharing workbooks limitations - Merged Cells 12
security, enabling macros to enable a disabling saving function 12
Problem in adding macro to ribbon through Add-in 7
Macro can not unprotect a sheet in a shared workbook 4
Running Macros in a Shared File 2
Opening a list of Excel files and run a macro in each 17
Excel is removing Macros from workbook 3

Top