+ Reply to Thread
Results 1 to 5 of 5

How to Share workbook for use morethan one user

  1. #1
    Registered User
    Join Date
    07-27-2014
    Location
    Saudi Arebia
    MS-Off Ver
    Microsoft 10
    Posts
    56

    Post How to Share workbook for use morethan one user

    Dear
    I Please help me to compleate my file
    i have VBA file this file i want to share to all System in the factory through LAN connected Z drive
    also same time morethan one user want to access for Edit and save this file

    please help me to get VBA code for this option


    br,
    nisar.mohammed

  2. #2
    Forum Contributor rajeshturaha's Avatar
    Join Date
    08-22-2012
    Location
    Assam, India
    MS-Off Ver
    Excel 2003, 2007
    Posts
    236

    Re: How to Share workbook for use morethan one user

    Go to Review>Share Workbook> and Tick [Allow Changes by more than one user at a time...]
    Rgd
    RT
    If my answer(s) helped you, please add me reputation by click on *

  3. #3
    Registered User
    Join Date
    07-27-2014
    Location
    Saudi Arebia
    MS-Off Ver
    Microsoft 10
    Posts
    56

    Re: How to Share workbook for use morethan one user

    dear
    i already did that but when i share my vba button not working (can't select)

  4. #4
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: How to Share workbook for use morethan one user

    Hi nisar.mohammed

    Do you get an error message such as "Project is Unviewable"? If so, see this link

    http://blog.contextures.com/archives...in-excel-2010/
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

  5. #5
    Registered User
    Join Date
    07-27-2014
    Location
    Saudi Arebia
    MS-Off Ver
    Microsoft 10
    Posts
    56

    Re: How to Share workbook for use morethan one user

    Dear if you have any VBA code to share workbook in Z drive to Work all People at a time

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 2
    Last Post: 07-29-2013, 12:19 PM
  2. Replies: 4
    Last Post: 01-16-2013, 05:40 PM
  3. Replies: 4
    Last Post: 04-24-2006, 02:00 PM
  4. How do I share a custom toolbar with another user?
    By Tasha in forum Excel General
    Replies: 1
    Last Post: 06-13-2005, 07:05 PM
  5. [SOLVED] Is it possible to share Excel workbook with a remote user??
    By Kunal in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-23-2005, 07:06 PM

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