+ Reply to Thread
Results 1 to 3 of 3

If I turn on track changes, can someone else turn it off?

  1. #1
    Registered User
    Join Date
    01-05-2018
    Location
    USA
    MS-Off Ver
    2016
    Posts
    12

    If I turn on track changes, can someone else turn it off?

    I want to Track Changes, but I don't want other people to turn it off after I've shared the workbook. Can another user (not me) do this?

  2. #2
    Forum Expert ben_hensel's Avatar
    Join Date
    01-26-2012
    Location
    Northeast USA
    MS-Off Ver
    Office 365
    Posts
    2,043

    Re: If I turn on track changes, can someone else turn it off?

    Review Ribbon Tab => Changes Panel => "Protect and Share Workbook" button

    In the dialogue box, click the tickbox for "Share with track changes"
    And put in the optional password.

    That's pretty much the upper limit of what you could do to lock Track Changes on. Password protection inside Excel is not terribly secure -- it's designed to prevent accidents or mistakes, rather than protection. So if any of your users decided to circumvent the password and remove Track Changes anyway, it's a Google search away.
    Click the [* Add Reputation] Button to thank people for help!
    Post Attachment: Click [Go Advanced] under the reply box; then click [Manage Attachments] to launch the attachments dialogue.
    Mark Thread Solved: Go to the top of the first post; Select [Thread Tools] dropdown; Pick the [Mark thread as Solved] option.

  3. #3
    Registered User
    Join Date
    01-05-2018
    Location
    USA
    MS-Off Ver
    2016
    Posts
    12

    Re: If I turn on track changes, can someone else turn it off?

    Ben_hensel,

    Thanks so much for that suggestion! I think that's the ticket, at least in so far as providing that level of safety.

+ 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: 1
    Last Post: 02-24-2017, 09:17 PM
  2. Manipulate Outlook Shortcuts (turn them on and turn them off) from excel vbascript
    By beckstei in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-23-2016, 10:46 AM
  3. Turn off calculations before query refresh....turn them back on after
    By mk3ll00 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-30-2014, 03:25 PM
  4. Auto calc on, then turn off, then runtime error how to turn back on
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-22-2011, 10:37 AM
  5. Replies: 1
    Last Post: 07-30-2010, 03:35 PM
  6. [SOLVED] Macro to turn on "Track Changes" function
    By John A in forum Excel General
    Replies: 0
    Last Post: 12-07-2005, 01:35 PM
  7. How do i turn it off
    By ceemo in forum Excel General
    Replies: 2
    Last Post: 05-25-2005, 07:25 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