+ Reply to Thread
Results 1 to 2 of 2

Prevent Workbook opening without a code or another file on the computer.

  1. #1
    Registered User
    Join Date
    11-06-2014
    Location
    Australia
    MS-Off Ver
    15.0.4659.1001
    Posts
    8

    Prevent Workbook opening without a code or another file on the computer.

    I am trying to find a solution to opening a workbook based on another workbook or code being present on the computer. If the code or workbook is there, the workbook will open otherwise it wont. I am hoping this will stop someone copying the file and opening it on another computer. Any help would be appreciated.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,936

    Re: Prevent Workbook opening without a code or another file on the computer.

    Excel security is notoriously weak. Anyone trying to open your file without the source file will automatically be given the option or opening without update. Not sure if there may be a VBA option for this though.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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] VB Code to restrict opening excel file for certain computer name only
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 04-07-2021, 07:51 AM
  2. vba excel - Prevent opening workbook with duplicate vba code but different file names
    By terriertrip in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 07-03-2018, 06:36 PM
  3. [SOLVED] Macto to amend code to prevent opening up a duplicate file
    By flupsie in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-15-2018, 01:24 AM
  4. VB code to check name of Computer before opening excel file.
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-15-2017, 04:25 PM
  5. Prevent Excel File from Copy, Move and Delete from computer
    By AmirSoft in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-22-2014, 04:43 AM
  6. Macro to not allow opening of file only on certain computer if it is already opened
    By Repent34 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 04-04-2011, 05:41 PM
  7. Replies: 1
    Last Post: 03-31-2006, 01:15 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