We have a spreadsheet with 4 tabs. We paste a spreadsheet into the first tab and tabs 2 thru 4 populate with specific information relative to those tabs. I want to protect the formulas in tabs 2 thru 4, but when I do, the user cannot use the filters as they may need to do. Can I protect the formulas in 2 thru 4 and still have the user change the filters? Thanks.
1) Turn on the Autofilter BEFORE you protect the sheet
2) When you protect the sheet, be sure to enable the [x] Use Autofilter option in the protections parameters.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
>Select the formula Range
>Go to "Format" > "Format Cell"
>Go to "Protection" > To Right Mark on both tab "Locked" & "Hidden" > Click "ok"
>Again go to "Format" > "Protect Sheet"
>Right click on "Select Lock Cells" / "Select Unlock Cells" / "Use AutoFilter"
>Enter password (which you want") > Click "ok" > Aginst enter same password (which you enter earlier)
>Click "ok"
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks