+ Reply to Thread
Results 1 to 8 of 8

Restrict users to rows

Hybrid View

  1. #1
    Registered User
    Join Date
    07-31-2009
    Location
    Cape Town
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Restrict users to rows

    Thanks for getting back to me.

    What sort of application would you recommend as an alternative?

    Could provide me with a brief description of how to enable this?

    Thanks Again

  2. #2
    Forum Expert Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007, 2010
    Posts
    3,978

    Re: Restrict users to rows

    If you want real security then use a Database.

    You might find this link useful as starting place: Prevent Unhiding of Hidden Sheets"]Prevent Unhiding of Hidden Sheets
    Last edited by Palmetto; 08-14-2009 at 08:55 AM.

  3. #3
    Registered User
    Join Date
    07-31-2009
    Location
    Cape Town
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Restrict users to rows

    Thanks again

    I have been out of the office and have not been able to reply.

    Unfortunately the link you suggested is broken. I would really apreciate it if you could send some more info.

    Thanks

  4. #4
    Registered User
    Join Date
    07-31-2009
    Location
    Cape Town
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Restrict users to rows

    I posted this question and I am still a bit unclear as to how to go about enabling this functionality.

    We need to restict users to view specific cells in a spreadsheet and each time that a user opens a spreadsheet it should possibly run a code and display different cells depending on who is opening the spreadsheet.

    The research I have done around this seems to indicate that perhaps I could password enable certain cells and show/hide cells depending on the password that is entered.

    I would really appreciate it if someone could assist me.

  5. #5
    Forum Expert Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007, 2010
    Posts
    3,978

    Re: Restrict users to rows

    Apologies for the broken link. I have now amended my earlier post and the link is working.

    I have to remind you that any user can choose to not enable macros, so don't be lulled into a false sense of security about users not being able to gain access to "hidden" cells (though you can make it difficult to do so).

  6. #6
    Registered User
    Join Date
    07-31-2009
    Location
    Cape Town
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Restrict users to rows

    Hi

    I attempted to access the link you suggested however it kept timing out.

    I assume that this cannot be done. I will attempt to achieve in another application.

    Thanks

+ 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