+ Reply to Thread
Results 1 to 2 of 2

VBA to protect workbooks.

  1. #1
    Registered User
    Join Date
    11-07-2019
    Location
    Lithuania
    MS-Off Ver
    Office 2013
    Posts
    52

    VBA to protect workbooks.

    Hello, i'm thinking of implementing a safety measure to prevent the usage of the my workbook by people who would really want to but shouldn't use it without my consent.
    The VBA i'm thinking of is to check if a USB drive is present with a specific while on it. Looks something like this:

    Please Login or Register  to view this content.
    So my question is: Would it be a good idea to implement something like this? Maybe there are better methods? Won't this solution backfire by making accessibility of the workbook impossible?

    Any help, insights and tips are really appreciated.
    Thank you.

  2. #2
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: VBA to protect workbooks.

    It’s largely a waste of time, to circumvent that, one could simply disable macros. It’s also trivial to change VBA code regardless of the measures you put in place. As long as you’re only trying to prevent casual use though, you should be fine, just be aware you can’t stop someone with a bit of know how or willingness to google!

+ 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. Marco to Lock/Unlock and Protect/Unprotect Multiple Excel Workbooks
    By Jgonza25 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-22-2013, 03:29 PM
  2. [SOLVED] VBA code to open mutliple workbooks and protect all data
    By kenadams378 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-17-2013, 09:00 PM
  3. Replies: 2
    Last Post: 01-17-2013, 08:39 AM
  4. [SOLVED] Protect & unprotect an array of worksheets across multiple workbooks
    By carwil in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-10-2012, 11:07 AM
  5. Protect / UnProtect all workbooks with a single button through VBA
    By acsishere in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 08-26-2010, 06:27 AM
  6. Shared workbooks and protect/unprotect problem
    By chris100 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-17-2007, 03:53 PM
  7. [SOLVED] Password protect a folder with several workbooks
    By tbugs in forum Excel General
    Replies: 2
    Last Post: 08-07-2006, 04:10 AM
  8. [SOLVED] Fancier Protect Sheets, Workbooks
    By John F. in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-15-2005, 01:05 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