Control user access using VBA through Account information

[Likith]

Hello,

I am just looking for some help here.

Is there any way to create a VBA code to control "Access to excel" based on Account information

For example, The excel file should open to only specific users based on their account information (Email) which are added in our VBA code.

Any thoughts are much appreciated!

Regards,
Likith

 

[mrshl9898]

You could add a workbook open event and check their username.

Unfortunately they would need to enable macros first...

Private Sub Workbook_Open() 

If Environ("username") <> my.name then
thisWorkbook.Close SaveChanges:=False
end if

End Sub

Password protection is probably the best bet.