# Running Macros on shared workbooks

• I have been creating macros for a shared file. When someone other than myself a complier error appears. Is there anyway around this?

• Re: Running Macros on shared workbooks

What error are you getting?

What are the macros doing? There are some limitations of what you can do with a shared workbook.

Do the other people have the same references as you when you goto Tools>References... in the VBA Editor?

Boo!:yikes:

• Re: Running Macros on shared workbooks

I am getting complilation errors when someone else other than me runs the macros.

For example, a used the Format function to change a label caption to read a currency. When I run it , it is fine. When someone else runs it, Excel can't find the function.

Does this make sense?

• Re: Running Macros on shared workbooks

Like I said check the references on the other person's machine.

Are they the same as yours?

Are any of them listed as MISSING?

Boo!:yikes:

• Re: Running Macros on shared workbooks

Yes, the same libraries are checked on both machines. I did a file save as to over-ride the earlier version

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!