Network Access For Excel
MZ Tools makes life easier for the Excel VBA coder
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Network Access For Excel

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    79
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    If I want to run a workbook in Excel and give several users access to the same file. Is there a way I can get Excel to stop the file opening if someone else already has write access to the file, possibly with a message like "Busy....Try again later".

    Don't know if this is possible but one way to find out is to ask you guys


    Thx Roy

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Las Vegas Nevada USA
    Posts
    239
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi RoyinUK2000
    Any network I have ever been on allows only one person at a time to use Excel unless it is set up in shared mode. Otherwise it can be opened in "Read only" condition by any one else.
    George
    George

    Learn to listen. Opportunity sometimes knocks very softly.

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Posts
    79
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I know this, what I am asking is can I stop a workbook opening if it is going to be opened in read only mode, i would rather a user not be able to get into the workbook than get into it in read only mode.

    Don't know if this is possible

    Thx
    Roy

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,169
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    H

    The data given is dafult Excel.. one live the others read only and can choose notify.. this is security...

    BUT...

    why not if restriction Mr A and B c d no access set a token ribg to secure the Folder the Doc lives in.. if stuck speak wit hthe IT dept thay can set this in 5 seconds flat and password protect..... simple as that..

    I have done this billions of times, you might need grouping access details to be amended under armagedon (whatever network you have)

    IT dept wont resist this if they do then they have not go a clue how to set networks inside network???

    HTH


    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com