Without selecting, try this on your hidden sheet. Of course the subject
cells would have to be unprotected for a protected sheet. If you really
don't want others to UNhide your sheet, hide/unhide with code using

sheets("tracker").visible=xlveryhidden 'true

with Sheets("Tracker")
.. Range("B3").Font.ColorIndex = 4
.. Range("C3")=date & time
end with
--
Don Guillett
SalesAid Software

"Pinda" wrote in message
...
Is it possible to run code on hidden sheets, without unhiding and hiding
back
the sheet in the process?

I have the following code

Sheets("Tracker").Select
Range("B3").Select
Selection.Font.ColorIndex = 4
Range("C3").Select
ActiveCell.FormulaR1C1 = "=NOW()"
Range("C3").Select
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False

I want the sheet 'Tracker' to be hidden always (even password protected),
so
the code Sheets("Tracker").Select will break down because there will be no
sheet to select.

Is it possible I can run the above code with the sheet 'Tracker' hidden?

Thanks in advance,

Pinda.