Close Menu Apple MS Office Windows Free Guides Author Digital Answers Apple MS Office Windows Free Guides Author Ravi Shankar 8 How to enable auto filter for protected sheet in A determined user could get around it by simply setting the cells to be unlocked. Thanks for the help guys. Any ideas? useful reference
Learn more about Allen... Show 8 Comments Jan May 8, 2013, 10:56 pm You just describe the function that's allready there, easy to find and that should do the job. Step 1: Make cells editable so that sorting will work. Note that this solution prevents changing or clearing cell contents, but does not prevent changing formats.
The question was how to make autofilter work in a protected worksheet because the mentioned function that should do it does'nt. Right click on the Sheet name tab, select View Code and paste in this; VB: Private Sub Worksheet_SelectionChange(ByVal Target As Range) Me.Protect Password:="Secret", UserInterfaceOnly:=True ActiveWindow.DisplayHeadings = False Application.DisplayStatusBar = False End http://answers.microsoft.com/en-us/office/forum/office_2010-excel/not-able-to-sort-on-a-protected-sheet-in-excel/d404fc30-6e59-4943-a828-abc7a2c0a37b Private10504 EXCEL HELP - How to Allow Sorting and Filtering in protected Sheet Posted: 06/27/2014 09:48am You can protect a sheet and allow certain criteria
Any ideas? –Ronald Valdivia Apr 17 '12 at 22:13 1.) make sure your range doesn't overlap with other ranges. 2.) unlock all cells in the sheet before applying a Why do most microwaves open from the right to the left? Enter your address and click "Subscribe." (Your e-mail address is not shared with anyone, ever.) Want to see what the newsletter looks like? How To Lock Filter In Excel 2010 share|improve this answer answered Mar 26 '14 at 21:55 Isaac Moses 89331738 add a comment| up vote 0 down vote If the autofiltering is part of a subroutine operation, you could
When you click on Protect Sheet the dialogue box that appears has check boxes to allow certain functionality to remain available. How To Use Filter In Protected Excel Sheet 2010 One of the things that the user can no longer do is to sort data. Will try to add better tutorials in future. Check a name to select it Group Invitations Choose invitation type Loading Ozgrid Excel Help & Best Practices Forums
is there any way to enable auotfilter. Excel Protect Sheet But Allow Drop Down The answer is quite easy: Excel allows you to specify what users can and cannot do with a protected worksheet. Scroll down the “Allow all users of this worksheet to” list and make sure to tick the check box with caption as “Use AutoFilter”. Using Excel 2013.
If you want to allow only certain people to sort, give the range a password. http://excelribbon.tips.net/T000137_Sorting_Data_on_Protected_Worksheets.html Please try the request again. Allow Filtering On Protected Sheet Vba Everything locks up and I get a message telling me I am trying to use auto filters on a protected sheet and I can't do that, and that I must unprotect Vba Allow Sorting Protected Sheet Should I report it?
All rights reserved.REDDIT and the ALIEN Logo are registered trademarks of reddit inc.Advertise - technologyπRendered by PID 7854 on app-585 at 2016-11-14 22:54:16.086577+00:00 running b744530 country code: GB. This site is for you! Why didn't "spiel" get an "sh"? Recent ClippyPoint Milestones! How To Lock Filter In Excel
Results 1 to 7 of 7 Thread: Unable to use Filters on a protected sheet + Thread Tools Show Printable Version Search Thread Advanced Search September 2nd, 2004 #1 Joozh An arrow should appear next to each column header. In the Protect Sheet dialog check the cells to allow sorting and filtering so that these actions can be performed.Still this has another implication which is the inability of reordering columns, this page Before locking the worksheet, select all the cells that you want people to be able to sort. (A great way to do this is to select one of the cells then
Thanks! How To Unlock Filter In Excel What if you want the user to be able to sort data, but still have the sheet protected? Can Newton's laws of motion be proved (mathematically or analytically) or are they just axioms?
Click "OK" Step 2: Prevent users from editing these cells When protecting the worksheet, uncheck "Select Locked Cells" worksheet protection property. This will prevent users from editing the cells. Remember Me? At the bottom of the dialog box is a long list of check boxes. http://europrolink.com/how-to/password-protected-tumblr-not-working.php Register To Reply 11-30-2009,10:57 AM #3 hai_krk View Profile View Forum Posts Registered User Join Date 07-25-2009 Location india MS-Off Ver Excel 2003 Posts 28 Re: To enable auto filter even
EDIT: Btw, I don't think it's possible to add filters once you've protected a sheet.