Results 1 to 7 of 7
  1. #1
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    sharing wB for set of users (xl97/xl2000)

    Is there a way to define up front the names of the actual users that you want a given workbook to be shared with? I've read that only 256 users can share a given workbook but I can't find a way to set the list of "approved" users. From Tools/Share I don't see a way to add names to the list. How do they get in there in the first place? Is it a first come, first view sort of thing?

    I'm asking because I want to restrict unauthorized users from viewing the workbook but am not allowed to use any macros (unfortuantely). I know I can protect the workbook but there's no guarantee that anyone will give out the password. I realize Excel isn't intended to be a secure system, but any bit would help.

    Thnx, Deb <img src=/S/grovel.gif border=0 alt=grovel width=31 height=23>

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: sharing wB for set of users (xl97/xl2000)

    Deb,

    Given what it says in Excel help on the topic :
    <hr>All users who have access to the network location where a shared workbook is stored have the same access to the shared workbook. <hr>
    it looks like there is not much you can do other than set up a sub folder with access granted only to those who are authorised to edit/read the file

    Sorry but that looks like your best solution.

    Andrew C

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: sharing wB for set of users (xl97/xl2000)

    If you are going to share the workbook, then obviously it is going to be on a network drive. Just put the workbook on a drive that only authorized users have access to.
    Legare Coleman

  4. #4
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: sharing wB for set of users (xl97/xl2000)

    All very good suggestions here. Unfortuately they can't put it on a shared drive since not everyone has network access (they're road warriors). Oh, well, it's back to SaveAs with password. Too bad everyone is so scared of macros/VBA (not that Excel can't be broken into....)

    Deb <img src=/S/bow.gif border=0 alt=bow width=15 height=15>

  5. #5
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: sharing wB for set of users (xl97/xl2000)

    If they don't have network access, how are they sharing the workbook? Do they have their own copy (which is not sharing)? If they have their own copy, how did they get it if they are not authorized?
    Legare Coleman

  6. #6
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: sharing wB for set of users (xl97/xl2000)

    Ah, very true. <img src=/S/clever.gif border=0 alt=clever width=15 height=15> The reason for all this confusion is we only want our employees to use the workbook and not give it to a customers who might then pass it to a competitor. If we could somehow determine when the workbook is opened, that the computer that is running it belongs to an employee, then everyone will be happy. The sharing thing was just a far-fetched idea at maybe finding a solution since we can't use macros. We can protect the workbook but there's no guarantee that an employee will give the password away either. (My other attempt at solving this was post #71458 but that was before I found out no macros were allowed.)

    Deb <img src=/S/nuts.gif border=0 alt=nuts width=15 height=15>

  7. #7
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: sharing wB for set of users (xl97/xl2000)

    If you can't trust the employees not to give out the password, and you can't use macros, I don't think you have any possible solutions. Excel passwords are fairly easily cracked, so that would probably not be a solution even if you could trust the employees. I do not know of anything else in Excel that would help without using Macros.
    Legare Coleman

Posting Permissions

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