Protect excel file with password and IP control
Project detail
Hi, i have an Excel file, i would like to protect it in this way. When it load asks for a password
If password1 (admin) is typed load the file
If password2 (user) is typed check for public IP
If the IP is in the whitlist —> load the file
If IP is NOT in the whitlist —-> remove all datas and the VB code and send an email to my
email address with public IP of the PC that opened the file, time and date.
The VBA code is password protected. Is it possible?