Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro running against hidden worksheet | Excel Discussion (Misc queries) | |||
Formula or Code to keep Hidden Rows Hidden | Excel Worksheet Functions | |||
Running a Macro from hidden Workbook | Excel Programming | |||
Code for Printing Hidden Sheets | Excel Programming | |||
running macros on hidden sheets? | Excel Programming |