I have a simple Macro I run on my sheets.
I want it to run each time I Deactivate a Sheet but I don't know how to make it happen.
Can anyone help?
Here is the code
****************
Sub Refresh_Page()
'
' Refresh_Page Macro
'
'
Range("Q8:s8").Select
Selection.AutoFill Destination:=Range("Q8:s58"), Type:=xlFillDefault
Range("Q8:s58").Select
End Sub
*****************
I do have some sheets I won't want it to run on.
I want it to run each time I Deactivate a Sheet but I don't know how to make it happen.
Can anyone help?
Here is the code
****************
Sub Refresh_Page()
'
' Refresh_Page Macro
'
'
Range("Q8:s8").Select
Selection.AutoFill Destination:=Range("Q8:s58"), Type:=xlFillDefault
Range("Q8:s58").Select
End Sub
*****************
I do have some sheets I won't want it to run on.