• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Filter Incon disabled on a protected sheet

C

chandrikaZephyr

New Member
Dear Team

I am working on a project, which involves locking down of excel files. Locking down of formulas, VBA code ,workbook structure and worksheet is what is intended. Users are given
ability to type in few specified cells. SO far so good.. but as side effect of this lock down, some icons like filter icon is disabled. Pivots refresh button is disabled. Edit to external links are disabled. Is there anyway we can have a customized excel ribbon so that these functions are retained on excel ribbon on protected sheets.

Thanks a ton
 
Hi @chandrikaZephyr

Welcome to the forum :)

I believe you can't have a sheet locked and still retain functionality that require unlocked access.
There are ways of dealing with this problem but they usually require some VBA code.

For instance, you could use worksheet SelectionChange events to remove protection from sheet as long as user is selecting the header, and lock everything up as soon as he exits that selection.
 
Hi @PCosta87

Thanks for the warm welcome and reply. Yes I have overcome some limitation by adding macros to remove protection and enable protection again. But filter Icon is needed by finance users, as they frequently need to remove and apply filters, which is possible only with Filter Icon available on the Ribbon. So I have some rough idea about XML, does that help me to build a customizable Ribbon on protected sheet.

Thanks for your time again
 
chandrikaZephyr said:
Hi @PCosta87

Thanks for the warm welcome and reply. Yes I have overcome some limitation by adding macros to remove protection and enable protection again. But filter Icon is needed by finance users, as they frequently need to remove and apply filters, which is possible only with Filter Icon available on the Ribbon. So I have some rough idea about XML, does that help me to build a customizable Ribbon on protected sheet.

Thanks for your time again
Click to expand...
Hi again @chandrikaZephyr

I was going through the protection options again and realized I forgot about a checkbox to "allow autofilters"... maybe you should give this one a go
It won't allow new filters, but will allow them to use existing ones (although it's probably not what you are looking for :()
 
You must log in or register to reply here.
Back
Top