Home Explorer

Vba-protect-sheet-with-autofilter-4, a lot of excel functionalities are also available to be used in vba – and the autofilter method is one such functionality. if you have a dataset and you want to filter it using a criterion, you can easily do it using the filter option in the data ribbon.. I have a sheet where columns b3:e65536 are unlocked. i want to be able to password protect the sheet & still be able to use the sort feature with autofilter. can this be acheived with a macro & if so any ideas on how i could do this?, in this articleunprotect excel worksheet without passwordunprotect excel worksheet with passwordunprotect sheet – lost passwordprotect worksheetsprotect worksheet – without passwordprotect worksheet – password protectprotect worksheet settingsprotect sheet – allow vba to make changesunprotect all sheets macroprotect all sheets macro this article will teach you everything about excel ....

Autofilter, group and ungroup on protected sheet hi all, i have a protected sheet named "00_ transactions". once i protect the sheet, i cannot group and ungroup the data. can this be solved using macro codes? if yes, can someone help me to created macro codes in order for me to group and ungroup and at the same time use autofilter functionality ..., enable autofilter and sorting on protected sheet hello, is there any way to allow auto filter and sorting on a protected sheet. i tried to check "use auto filter" and "sorting" options while protecting sheet, but i am still not able to apply filter. is it feasible in excel 2013? any suggestions, please. ....

Using this filter option we can play around with the data. if you are dealing with a minimal amount of data and if you think vba autofilter option not really required you can continue to use the worksheet filter option.