NBVC
Well-known Member
- Joined
- Aug 31, 2005
- Messages
- 5,828
I have a spreadsheet that I run a query with.
I have a simple worksheet event macro that forces cell G1 to always be active (that is the input cell for the query to refresh its data based upon)
I want to be able to temporarily "disable" that macro in order to click a button on the sheet.
Currently it won't let me click that button because of the worksheet event macro forcing cell G1 to be active....
Any suggestions on what I can do?
I have a simple worksheet event macro that forces cell G1 to always be active (that is the input cell for the query to refresh its data based upon)
Code:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Range("G1").Select
End Sub
I want to be able to temporarily "disable" that macro in order to click a button on the sheet.
Currently it won't let me click that button because of the worksheet event macro forcing cell G1 to be active....
Any suggestions on what I can do?