I have a workbook with macros which gets frequently updated and is used by separate users. What is the best way to ensure everyone is using the latest version?

Hi Paul

Thanks for your question. I am not sure how your users are accessing your Excel file, is it on a network, or emailed back and forth?
For simplicities sake, if the file is being email back and forth it would make sense just to have a file save convention and keep everyone in the loop.

If the file is being accessed by users over the network, you can set-up sharing rights within Excel, goto Tools, choose Share Workbook, then in the dialog box select check box "Allow changes by more than one user at the same time. This allows workbook merging"

I would strongly recommend that you experiment with a test file to understand the behaviour of this setup before using your real files.

Hope this helps.

Jacob