+ Reply to Thread
Results 1 to 3 of 3

Protect & Share Workbook

  1. #1
    Registered User
    Join Date
    10-28-2014
    Location
    NC, USA
    MS-Off Ver
    Office 2013
    Posts
    8

    Question Protect & Share Workbook

    I need the ability to share a workbook with others so they can work at the same time, but limit their entries to only additions. Protect the workbook from any deletions (cells/sheets/workbook). I know how to Share and I know how to Protect in Excel 2013, but it won't let me do both at the same time.

  2. #2
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    2,108

    Re: Protect & Share Workbook

    Use VBA. Use some macro that allows data entry. Like this:

    Please Login or Register  to view this content.
    Add it in the Worksheet module. Add an Option Explicit in ThisWorkbook module. Change the red part to the range you should protect
    Click the * to say thanks.

  3. #3
    Registered User
    Join Date
    10-28-2014
    Location
    NC, USA
    MS-Off Ver
    Office 2013
    Posts
    8

    Re: Protect & Share Workbook

    Thanks Paul for the advice. I couldn't get it to work on my computer, but it could be a security setting not allowing macros. I have someone checking it out for me.

+ 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: 0
    Last Post: 01-18-2014, 11:58 AM
  2. Replies: 2
    Last Post: 07-29-2013, 12:19 PM
  3. Protect and Share workbook - how to?
    By Eventful in forum Excel General
    Replies: 9
    Last Post: 03-06-2013, 06:13 PM
  4. Share and Protect a workbook
    By jghender in forum Excel General
    Replies: 1
    Last Post: 01-10-2013, 04:43 PM
  5. Share a workbook and protect sharing (VBA)
    By XLtech in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-20-2010, 02:32 PM
  6. How to protect the share workbooK
    By Calculate Date range in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-19-2005, 07:05 AM
  7. [SOLVED] share a workbook but protect the formulas
    By clemrogan in forum Excel General
    Replies: 2
    Last Post: 08-09-2005, 05:05 PM
  8. Replies: 5
    Last Post: 08-09-2005, 11:05 AM

Tags for this Thread

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