Macros run by one click
- Thread starter sachar
- Start date
AlanSidman
Well-Known Member
In a worksheet event
Code:
Option Explicit
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
ActiveCell.Value = "Hello World!"
End SubNARAYANK991
Excel Ninja
Hi ,
Another option is to insert a button on the QAT ; see the following link for how to do this :
http://blog.contextures.com/archives/2010/05/03/add-a-macro-button-to-the-excel-qat/
You should be aware that once a macro is linked to a button on the QAT , it can be clicked irrespective of which sheet is active ; this may cause unintended consequences if your macro is not working on any specific sheet(s) , but works on the active sheet.
Narayan
Another option is to insert a button on the QAT ; see the following link for how to do this :
http://blog.contextures.com/archives/2010/05/03/add-a-macro-button-to-the-excel-qat/
You should be aware that once a macro is linked to a button on the QAT , it can be clicked irrespective of which sheet is active ; this may cause unintended consequences if your macro is not working on any specific sheet(s) , but works on the active sheet.
Narayan