+ Reply to Thread
Results 1 to 5 of 5

Share workbook restrictions

  1. #1
    Registered User
    Join Date
    01-10-2008
    Location
    Hong Kong
    Posts
    22

    Share workbook restrictions

    Hi guys,

    I have a shared excel workbook on my drive which Im hoping to share with my people on my network. However, I have locked certain files which cannot be edited,but in addition, i have an auto filter to setup so users can use them accordingly.
    Many thanks
    Last edited by jodders; 01-18-2008 at 08:16 AM.

  2. #2
    Forum Expert dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Smile

    Good afternoon jodders

    What version of Excel are you using? If it is XL2002 or higher, then when you set protection, tick the Use Autofilter box in the Protect Sheet dialog.

    HTH

    DominicB
    Please familiarise yourself with the rules before posting. You can find them here.

  3. #3
    Registered User
    Join Date
    01-10-2008
    Location
    Hong Kong
    Posts
    22
    Its microsoft 2000

  4. #4
    Forum Expert dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Smile

    Hi jodders

    In that case look here for instructions how to make autofilters work with a protected worksheet.

    http://www.contextures.com/xlautofilter03.html#Protect

    HTH

    DominicB

  5. #5
    Registered User
    Join Date
    01-10-2008
    Location
    Hong Kong
    Posts
    22
    Mate,

    Thank you so much for you all your help, your very kind to point me in the right direction.


    Hope all is well

    J

+ 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