+ Reply to Thread
Results 1 to 3 of 3

Protect worksheet options

Hybrid View

sivdin Protect worksheet options 05-18-2011, 04:45 PM
sivdin Re: Protect worksheet options 05-18-2011, 05:48 PM
sivdin Re: Protect worksheet options 05-19-2011, 03:44 PM
  1. #1
    Forum Contributor
    Join Date
    04-21-2009
    Location
    Canada
    MS-Off Ver
    Excel 2003
    Posts
    112

    Protect worksheet options

    Hi Experts,

    While protecting a worksheet from Tools---Protection---protectsheet, We see lot of options in checkbox displayed under "Allow all users of this worksheet to"

    By default, I see only the following alone shows in tick status--- "Select locked cells"
    and "Select unlocked cells".
    My requirement is I need few more options to be to be in tick status such as "Sort" and "Usefilter".
    I need to customize by default such that the options whichever i require should be enabled by avoiding manual selection.

    How do we change the settings in excel?
    Any help please.... Thanks in advance..

  2. #2
    Forum Contributor
    Join Date
    04-21-2009
    Location
    Canada
    MS-Off Ver
    Excel 2003
    Posts
    112

    Re: Protect worksheet options

    Any help friends???

  3. #3
    Forum Contributor
    Join Date
    04-21-2009
    Location
    Canada
    MS-Off Ver
    Excel 2003
    Posts
    112

    Re: Protect worksheet options

    Any solution friends?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1