Electronic file system - VBA to inform when dates are older than 10 days

[ramatthews]

Hi All,

Hope you well and that someone can assist me. I want to start a electronic filing system for checkin in/out client files to personnel. The purpose of the system is to:

- Track the files at any time
- Keep individuals responsible

Ideally, I would love the spreadsheet to have the following functions:

- When the file is entered in by an administrator, and a staff member wants to check it our/in, that the sheet requires the administrator and staff member to each enter a password to acknowledge that the file has been checked out/in - I have NO idea how to do this, and I do not know if this is possible?

- File must be checked in within 10 days from check out. Is there a VBA which can inform the administrator which files are 10 days overdue when she opens the sheet. Then, as soon as she enters check in date, then the VBA is stopped and the dates satisfy the requirement - If this makes sense at all.

I do hope that someone can assist me with my queries. I am not sure if this is at all possible, but any help/guidance woud really be appreciated.

Thanks a ton,

RM

[Winon]

Hello ramatthews,

You could simply Date Stamp any Sheet in say Sheet1.Range("A1"), and with the Workbook_Open Event, Or Sheet_Change, add the the Code as below:

Please Login or Register  to view this content.

Regards.

[ramatthews]

Dear Winon,

Thank you for this.

Please see attached spreadsheet I am developing. Columns F and G are the important columns. I have a dropdown of certain parties in each column. Is it possible, that when a user is selected, a "password" box comes up for that user to enter their password before the selection can be accepted. Therefore, this stops other users to be able to draw files on other peoples names? I hope this makes sense.

I would really appreciate any help I can get.

Regards,

RM