Macro net storage workbook, permissions, change log

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Macro net storage workbook, permissions, change log

  1. #1
    New Member
    Join Date
    Feb 2013
    Posts
    31
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Macro net storage workbook, permissions, change log

     
    Ask for help with realization. There is a book (in the network storage) in the general access for many users. Usually open it separately. One user works - another can't .

    In the book everyone user has the own sheet on which can makes changes. Other users sheets access must be only on "view".

    Exclude general sheet on which all can make changes, but needs change log on each network user (who changed when and what).

    So:

    Nessesary access via network for simultaneous work of all users;
    1. Access to the book for simultaneous editing via local network.
    2. Each user has access only to the own sheets,, other sheets are available to viewing only. And each user has access to the general sheet (1st in workbook) "on edit", but change log of each user is must conducted.

    I am at a loss with realization as to carry out it and not to overload the change log. Beautiful and simple realization on me obviously cries.

  2. #2
    MrExcel MVP
    Moderator
    Andrew Poulsom's Avatar
    Join Date
    Jul 2002
    Posts
    73,092
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Macro net storage workbook, permissions, change log

      
    You can Share a workbook, but read this first:

    Avoiding Shared Workbooks in Excel | Contextures Blog
    Microsoft MVP - Excel

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