Protect Excel sheet to be run on one PC only

%3CLINGO-SUB%20id%3D%22lingo-sub-2625607%22%20slang%3D%22en-US%22%3EProtect%20Excel%20sheet%20to%20be%20run%20on%20one%20PC%20only%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2625607%22%20slang%3D%22en-US%22%3E%3CP%3EWelcome...%20Is%20it%20possible%20to%20protect%20an%20Excel%20file%20so%20that%20it%20only%20opens%20on%20certain%20computers%20(identified%20by%20computer%20name%20or%20some%20unique%20hardware%20identification%20like%20MAC%20address%20etc.)%3F%20Let%20me%20lay%20out%20my%20requirements%20in%20detail%3A%20I%20have%20an%20excel%20file%20%22Y%22%20created%20in%20my%20computer%20named%20(x1).%20Anyone%20can%20open%20this%20file%20on%20this%20computer...%20I%20want%20to%20make%20this%20file%20(Y)%20work%20on%20a%20certain%20group%20of%20computers%20that%20I%20specify%20and%20with%20my%20consent%2C%20for%20example%20on%20three%20other%20computers%20only%2C%20(X2%2CX3%2CX4)%2C%20and%20it%20cannot%20be%20opened%20on%20others...%20If%20possible%2C%20I%20would%20like%20to%20use%20the%20protection%20method%20for%20some%20of%20my%20excel%20files..%20Thanks%20in%20advance%20for%20any%20help%20in%20this%20regard.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2625607%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2625932%22%20slang%3D%22en-US%22%3ERe%3A%20Protect%20Excel%20sheet%20to%20be%20run%20on%20one%20PC%20only%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2625932%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1123476%22%20target%3D%22_blank%22%3E%40nasir1969%3C%2FA%3E%26nbsp%3B%20check%20the%20VBA%20script%20below%2C%20it%20allows%20only%20authorized%20computers%20to%20access%20your%20Excel%20sheets%2C%20the%20Excel%20workbook%20should%20be%20protected%20and%20sheet1%20should%20not%20be%20deleted%20or%20renamed.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20title%3D%22allowing%20specific%20computers%20only%20to%20open%20a%20protected%20workbook%22%20href%3D%22https%3A%2F%2Fmartinbosanacvba.blogspot.com%2F2021%2F08%2Fallowing-specific-computers-only-to.html%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Eallowing%20specific%20computers%20only%20to%20open%20a%20protected%20workbook%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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

@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.

 

allowing specific computers only to open a protected workbook