+ Reply to Thread
Results 1 to 7 of 7

Protect Document Allow Editing With VBA

  1. #1
    Forum Contributor
    Join Date
    07-14-2019
    Location
    Dubai
    MS-Off Ver
    2019
    Posts
    919

    Protect Document Allow Editing With VBA

    Hello

    Looking to protect document with VBA code, and allow any orders from VBA code, its possible?
    in Excel UserInterFaceOnly solve this, is anyway to solve it in Word without unprotect?

  2. #2
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Protect Document Allow Editing With VBA

    That really depends on what kind of protection you're using. For example, if it's 'filling in forms' protection:
    Please Login or Register  to view this content.
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

  3. #3
    Forum Contributor
    Join Date
    07-14-2019
    Location
    Dubai
    MS-Off Ver
    2019
    Posts
    919

    Re: Protect Document Allow Editing With VBA

    Thanks alot, I think here u mean "=" not "<>"
    Please Login or Register  to view this content.

  4. #4
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Protect Document Allow Editing With VBA

    No, the code is meant to be as posted.

  5. #5
    Forum Contributor
    Join Date
    07-14-2019
    Location
    Dubai
    MS-Off Ver
    2019
    Posts
    919

    Re: Protect Document Allow Editing With VBA

    How to protect if the Document Protection State not equal unprotected? (mean already protection)

  6. #6
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Protect Document Allow Editing With VBA

    If the document isn't protected, you can protect it with code like:
    Please Login or Register  to view this content.

  7. #7
    Forum Contributor
    Join Date
    07-14-2019
    Location
    Dubai
    MS-Off Ver
    2019
    Posts
    919

    Re: Protect Document Allow Editing With VBA

    its working but sometime getting this error
    error 4605 this command is not available
    I am trying to unprotect document in document open event then hide application and show userform1, and in userform query close, protect again
    I am getting error in document open event .unprotect

+ 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. Protect pdf from editing after convert from excel
    By Neilesh Kumar in forum Excel General
    Replies: 1
    Last Post: 08-17-2016, 10:38 AM
  2. Protect text box from deletion but allow editing
    By Jerbinator in forum Excel General
    Replies: 0
    Last Post: 02-12-2016, 08:33 AM
  3. Protect a sheet from editing, but allow AutoFilter
    By sinapourazima in forum Excel General
    Replies: 6
    Last Post: 07-26-2014, 03:44 PM
  4. Excel 2007 : editing a document
    By JayHargrave in forum Excel General
    Replies: 1
    Last Post: 03-22-2010, 08:34 PM
  5. Protect Sheet: Allow cell editing but nothing else
    By jodyflorian in forum Excel General
    Replies: 3
    Last Post: 03-10-2008, 09:06 AM
  6. [SOLVED] Document editing
    By marlin in forum Excel General
    Replies: 5
    Last Post: 04-10-2006, 06:15 PM
  7. How to protect a workbook for editing only?
    By puneetarora_12 in forum Excel General
    Replies: 1
    Last Post: 03-15-2005, 01:34 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