+ Reply to Thread
Results 1 to 5 of 5

How to programmatically lock vb code w/o sendkeys

  1. #1
    Forum Contributor
    Join Date
    10-02-2013
    Location
    Harrisburg, PA
    MS-Off Ver
    Office 365 MSO (16.0.10730.20264) 32-bit
    Posts
    160

    How to programmatically lock vb code w/o sendkeys

    Hi all.
    I found how to unlock vb code: https://stackoverflow.com/questions/...t-from-vb-code
    But, cannot find how to lock it backup.

    Thanks for the help.
    Steve

  2. #2
    Forum Expert
    Join Date
    07-23-2018
    Location
    UK
    MS-Off Ver
    O365 32bit (Windows)
    Posts
    1,980

    Re: How to programmatically lock vb code w/o sendkeys

    If the the "Lock project for viewing" checkbox remains ticked, it will be locked again when the file is next opened.

  3. #3
    Valued Forum Contributor
    Join Date
    12-30-2020
    Location
    Odessa / Ukraine
    MS-Off Ver
    2021
    Posts
    301

    Re: How to programmatically lock vb code w/o sendkeys

    Hello @Steveapa.
    Maybe?
    NOTE: As the original poster/owner, only you can mark your thread as SOLVED (Thread Tools above Post #1).
    You can say "Thanks" in your thread to everyone who offered to help you.
    You can also reward them by clicking * "Add Reputation" under their username on the left.
    With Regards, MikeVol.

  4. #4
    Forum Contributor
    Join Date
    10-02-2013
    Location
    Harrisburg, PA
    MS-Off Ver
    Office 365 MSO (16.0.10730.20264) 32-bit
    Posts
    160

    Re: How to programmatically lock vb code w/o sendkeys

    I agree. But, that means after I do a code update, I need to save and close. I would prefer to not close. That causes issue with where the file is saved. If someone opens the file that is an attachment to an email, I would prefer not to save / close.

  5. #5
    Forum Contributor
    Join Date
    10-02-2013
    Location
    Harrisburg, PA
    MS-Off Ver
    Office 365 MSO (16.0.10730.20264) 32-bit
    Posts
    160

    Re: How to programmatically lock vb code w/o sendkeys

    Hi Mike.. let me check

+ 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. [SOLVED] Application.SendKeys issue with Num Lock
    By Un-Do Re-Do in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-13-2020, 04:55 AM
  2. [SOLVED] VB code for SendKeys
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-17-2016, 01:48 PM
  3. [SOLVED] VB Code to use SendKeys
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-28-2016, 12:40 PM
  4. Adding sendkeys to code:
    By EasyBreeze in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-22-2010, 01:47 PM
  5. [SOLVED] What's the syntax error with this SendKeys code?
    By Phil1982 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-19-2006, 02:55 PM
  6. How to edit VB code programmatically
    By Jon in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-09-2005, 08:06 PM
  7. Replace Code Programmatically
    By Datasort in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-26-2005, 02: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