+ Reply to Thread
Results 1 to 2 of 2

How to allow others to use edit and save a workbook with lots of Macros

  1. #1
    Forum Contributor
    Join Date
    01-09-2016
    Location
    Surrey B.C.
    MS-Off Ver
    2013
    Posts
    155

    How to allow others to use edit and save a workbook with lots of Macros

    Greetings

    When my partner use my workbook on his computer everything works except the automatic save macro.

    It prompts "You do not have permission to save in this location. Contact the Administrator to obtain permission"

    How do I give him permission?

  2. #2
    Forum Guru
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,032

    Re: How to allow others to use edit and save a workbook with lots of Macros

    The save macro is trying to save to a certain folder on your hard drive.

    You need to rewrite that to save to his hard drive.
    Please Avoid Joining My List Of Blocked Users by:

    Saying Please and Thank you.

    Making requests not demands.

    Checking back on your post. I will not edit any post after 4 days.

    Marking threads as closed once your issue is resolved. How? The tools at the top

    Any reputation (*) points appreciated. None of us gets paid here.

    If you found someone's input useful, please take a second to click the * at the bottom left to let them know

+ 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: 4
    Last Post: 05-30-2017, 02:17 PM
  2. Make workbook read only with no ability to save or edit
    By mmazz365 in forum Excel General
    Replies: 2
    Last Post: 02-04-2015, 02:45 PM
  3. Can't save Workbook with macros after changes
    By IrinaKr in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-11-2014, 07:35 AM
  4. Create, edit and save workbook from list of data
    By mwhitedesigns in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-02-2013, 01:02 PM
  5. Create, edit and save workbook from list of data
    By mwhitedesigns in forum Excel General
    Replies: 1
    Last Post: 12-21-2012, 12:46 PM
  6. Edit listbox selected items and save to workbook???
    By madforit in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-23-2012, 08:00 AM
  7. Add, edit, delete, save functions in excel using macros
    By tweety127 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-22-2006, 05:20 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