| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro for running on preotected sheets
Thanks for your help Mike H & Wigi. Code works fine.
"Wigi" wrote: You can protect your sheet with the argument UserInterfaceOnly set to True. -- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music "Yogin" wrote: Hi All, I am using the code below but when I protect the sheet it doesn't work, can someone help on this problem please. Sub TeamLeadersLates() Dim MyDate As Date, StringDate As String With Sheets("Daily Sheet") StringDate = InputBox("Enter Date") If IsDate(StringDate) Then MyDate = DateValue(StringDate) .Range("E2") = MyDate Else MsgBox "Invalid Date" Exit Sub End If .Range("$B$4:$D$1000").AutoFilter Field:=1 .Range("$B$4:$D$1000").AutoFilter Field:=4 .Range("$B$4:$D$1000").AutoFilter Field:=4, Criteria1:="LTL" Sheets("Daily Sheet").Select End With End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| multiple wk sheets - running balance | Excel Discussion (Misc queries) | |||
| Running total between sheets | Excel Discussion (Misc queries) | |||
| Sheets("Rpt").Copy different results from running in macro than off excel menu?? | Excel Discussion (Misc queries) | |||
| If I have my sheets protected will that prevent me running a macro to hide certain sells? | Excel Worksheet Functions | |||
| calc locks up after running a macro that moves sheets to a new fil | Excel Discussion (Misc queries) | |||
Threaded Mode
