Macro that work from another sheet when my worksheet is hidden

[Jeffreyxx01]

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()"
    Range("BK1").Select
    Selection.Copy
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False
    Application.CutCopyMode = False
End Sub

 

[jproffer]

Yes, from what I've seen VBA will assume you mean do (whatever) on the active worksheet unless you specify otherwise. So since your sheet is hidden, you'll have to name it, correct.

Worksheets("Name").Range("BK1") = Date

the sheet being hidden wont affect the procedure at all, you just wont see it happen or that it happened until you unhide the sheet.