Re-protect An Excel Sheet, Enabling Auto-Filters?Sep 12, 2011
I'm using VB.net 2005 to input data from a database application into Excel files.I un-protect the sheets, input data into specific cells using named ranges, then re-protect the sheets.
This has worked fine so far, up until I ran into a file that is protected with auto-filtering enabled. When I re-protect the sheets, I can't seem to protect it while allowing the use of autofilter dropdowns. The dropdown arrows for the autofilter are greyed out and disabled.
Using the following code to re-protect the sheets after inputting the data.
works fine. The sheet is protected and I can use the autofilter drop downs. But when I use that same code in my VB.net project, the drop downs are not enabled.