Activate or Deactivate Object(This workbook) Macros

Status
Not open for further replies.

madhuchelliah

Board Regular
Joined
Nov 22, 2017
Messages
153
Hello Guys Is there any module macros to activate and deactivate the macros in excel objects(Thisworkbook or sheet)?

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
ActiveSheet.Range(Cells(ActiveCell.Row, 3), Cells(ActiveCell.Row, 25)).Select
End Sub
 
Last edited:

Some videos you may like

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.
Status
Not open for further replies.

Watch MrExcel Video

Forum statistics

Threads
1,099,029
Messages
5,466,116
Members
406,468
Latest member
Toto Li

This Week's Hot Topics

Top