How to use an event macro in all the workbooks that the user opens?

[arunkmr88]

Hi all,

I've been trying to develop an event macro[dbl_click event] to be used in all workbooks that the user opens once they toggle a button to on. And it should stop if they select off.[preferred radio buttons] .

After, an extensive search, I found that it can be made possible with the help of class modules.

Kindly guide me as im stuck and not able to move on and also suggest me if I'm on the right path.

The following code comes under class module

Private WithEvents App As Application


Private Sub App_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Dim strRange As String
strRange = Target.Cells.Address & "," & _
Target.Cells.EntireColumn.Address & "," & _
Target.Cells.EntireRow.Address
Range(strRange).Select
End Sub


Private Sub Class_Initialize()
    Set App = Application
End Sub

How should i use this to enable/disable as per user requirement of the user.

 

[arunkmr88]

Hi MVPs..

Is there a way to this? kindly help me out.

Thanks

 

[RoryA]

You need to put that code into a class module in an add-in, then use an event of your optionbuttons to create a new instance of the class, or destroy it as applicable for switching it on and off.