Disable Advanced filter option in Excel

I protect the Excel by hide some rows using protecting worksheet function.

However it was found when the user select "Advanced Filter" function, they can unhide all rows in the worksheet

any ways to prevent this?? Help...pls
hkgalAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

David_HagermanCommented:
0
hkgalAuthor Commented:
it's already password protected....but users can still select the choice "advanced filter"....
0
David_HagermanCommented:
When you selected protection did you de-select the options below

Select Locked Cells
Select unlocked cells

Also what version office are you using as i have tested this in office 2010
0
Introduction to R

R is considered the predominant language for data scientist and statisticians. Learn how to use R for your own data science projects.

hkgalAuthor Commented:
office 2003

I try this command on workbook_open():

Application.CommandBars("Data").Controls("Filter").Controls("Advanced Filter...").Enabled = False

but when another user open it, still appear "Advanced Filter"...
0
hkgalAuthor Commented:
I've requested that this question be deleted for the following reason:

I have solved by my own
0
David_HagermanCommented:
Poor form to cancel the request when you haven't solved the problem as per your comment " but when another user open it, still appear "Advanced Filter". "

Here is an article that steps it out.
http://www.accountingweb.co.uk/anyanswers/excel-prevent-hidden-columns-being-seen 

Also I have tried this on Excel 2003 between two machine and users can not un-hide the hidden sheet.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.