Restrict opening of an Excel outside the organization

[exl]

I have an excel which contains classified information. It does not contain any macro. I have put in workbook level security so employees cannot check the 'veryHiddenSheets'. I am ok with employees copying the data etc, but I don't want anybody outside the organization opening it. The excel workbook should only open within the organization.

I had seen a macro somewhere which checks the username and provides relevant data, can a similar strategy be used to check for a Domain or something (bcoz our logins is within a domain) and then provide access to the document. Eagerly awaiting some answers, else I won't be able to circulate the document.

 

[royUK]

That worked

You were looking for my computer in the opening code.

You didn't unprotect the workbook in the Close event.



File here

 

[exl]

That worked

You were looking for my computer in the opening code.

You didn't unprotect the workbook in the Close event.



File here

Wow, that worked fine... seems you have solved all my issues...

Many thanks Roy!

 

[royUK]

Glad it worked.

I suggest you compare the two code 7 see what I changed.