Sedang Disiapkan

Multiple Password Protection with Expiration

I have an Excel workbook that I would like to have password protection added. I would like to be able to have multiple users and passwords which would expire after specified dates. For example, I want UserA to be able to sign in for one month to use the worksheet (on a trial basis). After one month, they would be able to open the workbook with their password; however, they would no longer be able to edit it.

Here are the full-requirements:

(1) The entire workbook must have a requirement for macros to be enabled before launching the password requirements. If macros are disabled, they would see a warning sheet saying that they need to enable macros. (I don't want users to be able to see any of the data worksheets unless they enter a password. I want users to be feel assured that their data won't be read without first entering a password.)

(2) I want a worksheet where I can add an unlimited number of UserNames, Passwords, and expiration dates. I would then hide the worksheet.

(3) If the UserName and Password are correct, but the expiration date has passed, the worksheets would be shown; however, they would not be able to be edited (no changing the cell values, however, they would be able to see the data, copy it, and print any graphs).

Kemahiran: Excel

Lihat lebih lanjut: protection one, example graphs, correct username, copy edited, excel expiration log, protecting excel workbooks expiry, excel expire hide, multiple pasword excel, protection, expire, date entire, copy protection, multiple excel, add macros, excel month correct, excel print sheet, excel add macros, data hide

Tentang Majikan:
( 1 ulasan ) Oneonta, United States

ID Projek: #286899

Dianugerahkan kepada:

svet63

VBA developer since 1997. I know how to do it. Regards, Svet.

$175 USD dalam 3 hari
(46 Ulasan)
6.1

12 pekerja bebas membida secara purata $135 untuk pekerjaan ini

HussienSharaf

HI, i m the best VBA developer. i have good ideas for implementing this little security system thanks

$220 USD dalam 4 hari
(13 Ulasan)
5.2
ioanaprof

Hello, It can be done in terms of you. Ready to start. Thanks

$100 USD dalam 3 hari
(12 Ulasan)
3.5
excelinnovation

Hi, please see PMB. Regards

$100 USD dalam 4 hari
(7 Ulasan)
2.7
refractocd

Hello, this can certainly be done. I will get back with more details and a small demo. Please refer to PMB for details

$150 USD dalam 3 hari
(3 Ulasan)
2.5
vmalykh

Hi. I'd like to work with you. I can provide original and safe solution. Please see PMB for details. Good luck!

$180 USD dalam 5 hari
(3 Ulasan)
1.2
cg4you

Hi there, I have a very good experience in VBA programming and I've done a lot of tools in Excel. Just allow me to help you implementing this project. Have a nice day! Best Regards, George Ciuperca

$150 USD dalam 2 hari
(2 Ulasan)
1.2
CorpGrlTrinh7

This can be done easily.

$180 USD dalam 2 hari
(0 Ulasan)
0.0
ExcelGuy

I'll will build the macro and will delivered to you fully tested and bug free. please contact me. Thanks

$160 USD dalam 3 hari
(0 Ulasan)
0.0
raghavmp17

I have understood your requirements and I can complete this task very quickly with bug free.

$100 USD dalam 2 hari
(0 Ulasan)
0.0
emraanelaahi

I know how do we do this.. lets start

$65 USD dalam 6 hari
(0 Ulasan)
0.0
tazulislam

Dear Sir, I have five years working experience in Ms. Excell, Tally Software. Now I am working as a Senior Officer, Finance in Ascent Group. If you give me opportunity to work with you I will be glad. Your nic Lagi

$45 USD dalam 5 hari
(0 Ulasan)
0.0