Hi Nick,
I am an excel novice (especially when it comes to VBA script). Could
you look at the code below and give me some advice on where the
protect/unprotect script should be placed?
Sub RefreshScreen()
'
' RefreshScreen Macro
' Macro recorded 15/08/2006 by Damian Dancer
'
' Keyboard Shortcut: Ctrl+r
'
Selection.AutoFilter Field:=5
Cells.Select
Cells.EntireRow.AutoFit
Selection.AutoFilter Field:=5, Criteria1:="Blown Bulbs"
Range("A1").Select
End Sub
Your helps appreciated
--
damiand_1982
------------------------------------------------------------------------
damiand_1982's Profile:
http://www.excelforum.com/member.php...o&userid=37461
View this thread:
http://www.excelforum.com/showthread...hreadid=571224