This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Maybe the answer is a simple no, but I figured I'd ask. I just want to run a simple macro that performs a filter function so I can hide the filter arrows and simplify the filtering. When I try to run the macro while the sheet is protected, I get the following error message "Run-Time error '1004' You cannot use this command on a protected sheet. When I select "debug" the code window opens but I have no idea what to add or where. This is the entirety of the macro:Keyboard Shortcut: Ctrl+y
'
Selection.AutoFilter Field:=4, Criteria1:="TRUE"
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Comments have been turned off. Learn more
Thanks Mike, but unfortunately I don't understand what I'm supposed to do with the info you provided. Do I paste part of that into my code or into the password box?
This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Comments have been turned off. Learn more
Awesome, it worked perfectly once I played with the positioning of the lines within the code box (what can I say, I'm new).
Thanks!
(what can I say, I'm new).
For a newbee the learning curve is steep but satisfying. Glad I could help and thanks for the feedback.
If this post answers your question, please mark it as the Answer.
Mike H