Hi
I need my macro to work from another sheet when my worksheet is hidden
Can anyone help and explain how to do it,
Sub Date_Change_Weekly()'
' Date_Change_Weekly Macro
'
Dim Sht As Worksheet
Set Sht = ActiveWorkbook.Sheets("Pipeline")
Sht.Cells.FormulaR1C1 = "=TODAY()"...