Protect excel file with password and IP control

  • Job DurationLess than a week
  • Project LevelBasic Level
  • Project deadlineExpired

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?

Skills Required

Industry Categories

Freelancer type required for this project