Forum Discussion

nasir1969's avatar
nasir1969
Copper Contributor
Aug 08, 2021

Protect Excel sheet to be run on one PC only

Welcome... Is it possible to protect an Excel file so that it only opens on certain computers (identified by computer name or some unique hardware identification like MAC address etc.)? Let me lay out my requirements in detail: I have an excel file "Y" created in my computer named (x1). Anyone can open this file on this computer... I want to make this file (Y) work on a certain group of computers that I specify and with my consent, for example on three other computers only, (X2,X3,X4), and it cannot be opened on others... If possible, I would like to use the protection method for some of my excel files.. Thanks in advance for any help in this regard.

1 Reply

  • Vedran_Loani's avatar
    Vedran_Loani
    Copper Contributor

    nasir1969  check the VBA script below, it allows only authorized computers to access your Excel sheets, the Excel workbook should be protected and sheet1 should not be deleted or renamed.

     

    https://martinbosanacvba.blogspot.com/2021/08/allowing-specific-computers-only-to.html 

     

     

Resources