Running Macros on shared workbooks

  • 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?

  • 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


    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!