This question has likely been posted and answered 100 times, but I'm just trying to run a simple macro on a quote tool to provide my coworkers. It's super simple, see below:


Sub DisplayQuote()
' DisplayQuote Macro
' Keyboard Shortcut: Ctrl+Shift+D
'ActiveSheet.Range("$A$16:$A$79").AutoFilter Field:=1, Criteria1:="<>"
End Sub

Sub UndoDisplay()
' UndoDisplay Macro
' Keyboard Shortcut: Ctrl+Shift+U
'ActiveSheet.Range("$A$16:$A$79").AutoFilter Field:=1
End Sub

How can I run this on a protected sheet? Help??