Importing operating system information into excel.

[Stanles]

Hi all,

I am currently wondering how to allow only a single user to use my excel spreadsheet. That is I send it to the person, they download it, and then if they try to send it to someone else, the formulas in the spreadsheet stop functionning.

My inital thought was to make a formula ,using VBA or not, that would check the name of the device on which the excel spreadsheet has been opened. For that I was thinking of accessing the control panel but I have no clue on how to do it.

Any suggestions?

Thank you in advance!

 

[footoo]

Environ("UserName")

This could be used in a WorkbookOpen procedure (e.g. if not the approved user then close the workbook). Of course, the user must have macros enabled.
You might want to prevent access unless macros are enabled : Prohibiting the File from Opening if Macros are Disabled?

 

[Stanles]

Environ("UserName")

This could be used in a WorkbookOpen procedure (e.g. if not the approved user then close the workbook). Of course, the user must have macros enabled.
You might want to prevent access unless macros are enabled : Prohibiting the File from Opening if Macros are Disabled?

Thanks I will try that and let you know!