Sharing VBA Events Code With Others

Topic

New Reply

I have some code that I would like to share with users on our network. The code detects a double click event. It resides in ThisWorkbook module of an Excel workbook.

I can share code and functions other ways but how can I share this events code without having to update everyone’s workbooks indivdually?

Reply | Quote

Replies

That code is specific to that workbook and cannot be shared. You need to create an add-in with an Application variable declared WithEvents so that you can respond to the Application_SheetBeforeDoubleClick event. See Chip Pearson’s site here for example.

Reply | Quote

Excellent. Thanks!

Reply | Quote

Taking this one step further, Word has the convient template file that allows you to update code for all the template users just by switching out the template or making changes to it. Is there a similar feature in Excel?

The problem with having code in one file is that all users sharing that code have to be updated individually. Can an addin be used but tied into the WithEvents?

Reply | Quote

Excel works completely differently from Word as far as templates go, so there is no equivalent.
If you use the WithEvents code in an add-in that you store centrally, you can update all users simply by updating the central add-in. For details of how to do that, see Ken Puls site here.

Reply | Quote