LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Enabling Autofilter and Sorting in a Protected Sheet

Is it possible to "Allow" Sorting and use of Autofilter with respect
to Locked cells when the worksheet is Protected?

Even though I have checked both 'Sort' and 'Use Autofilter' under the
"Allow all users of this worksheet to:" options list, when enabling
protection, I am not able to perform either operation when the target
cells are Locked.

If I set the cells to be sorted or filtered to be Unlocked then it
works just fine when the worksheet protection is enabled.

I have "read" that by selecting the appropriate "Allow users to ...."
option the desired functionality should work with respect to target
cells that are set to the Locked status - what do I need to do
differently?

Any guidance would be greaty appreciated.

Thanks!

John
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Enabling formulas in a semi-protected sheet cbr Excel Worksheet Functions 0 November 22nd 10 01:36 PM
Use autofilter with macro in a protected sheet Minos Excel Discussion (Misc queries) 1 August 4th 09 03:44 PM
Autofilter in protected sheet Javier Excel Worksheet Functions 5 March 24th 08 05:56 PM
Applying autofilter to protected sheet Brian Ferris Excel Discussion (Misc queries) 2 November 18th 05 04:28 PM
Enabling macros while the sheet being protected ! dinesh Excel Discussion (Misc queries) 13 September 27th 05 08:47 PM


All times are GMT +1. The time now is 10:45 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"