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!