best training excel vba - version control vba

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » best training excel vba - Version control in vba

best training excel vba - Version control in vba

resolvedResolved · Low Priority · Version Standard

Paul has attended:
Excel VBA Intro Intermediate course

Version control in vba

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?

RE: version control in vba

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


 

Excel tip:

Move to edge of data block

When data is held in a block, however large, use the Ctrl key with your cursors to move quickly to the far edge of the block. Works with all 4 direction keys.

View all Excel hints and tips


Server loaded in 0.09 secs.