Rejje
05-30-2011, 06:04 AM
Hi!
How do I change below code to call for the macros with the change of Range("EXP_01") rather than with the change of anything within the worksheet?
Public Sub Worksheet_Change(ByVal Target As Range)
Call HideColumns_KP
Call HideRows_KP
Call FontSize
End Sub
How do I change below code to call for the macros with the change of Range("EXP_01") rather than with the change of anything within the worksheet?
Public Sub Worksheet_Change(ByVal Target As Range)
Call HideColumns_KP
Call HideRows_KP
Call FontSize
End Sub