We have a Excel Workbook, that has custom formula's that need to be protected.
1. Only works on Laptop/PC that we approve for each Excel file, should not work on virtual machine.
2. Get connected to internet to check date & time before allowing user to access that we set. Exceed the time frame, the file should not be open.
3. User cant disable micro/etc.
4. Or prefer user to input username & password, and cross check with a running server before allowing the excel file to open.
1. Each excel file only will works on 1 PC/Laptop, not even VM.
Example, Mr. A has the excel file that were assigned to Laptop A, he can only use the excel on Laptop A, not any other PC/Laptop /google sheet/cloud
2. Excel file will have an ID, email address and password as they open, and it will check ID status to hosting server for valid ID & password and Expiry date. For now, we're thinking just a text file or DB (MySQL) that hosted at web hosting, it reads for ID and date, any other better suggestion, are welcome, we're expecting more than 10 users for start, the list can grow bigger.
3. All excel file will check local date and time via any NTP ip for the current date and time.
4. Once ID and current dates are met, then user will be able to work on the excel file.
5. If working on macro's, need to ensure user cant disable macro's or bypass it.
6. The excel file are worksheet protected, and it only allows certain cells to edit. Client must not able to copy out any details from the sheet to new worksheet/excel/etc.
8 freelancers are bidding on average RM82 for this job
hello sir how are you .im very happy if you went give me your project im very serieus and worker . Relevant Skills and Experience excel data entry Proposed Milestones RM48 MYR - 30 please give me your project