I seem to have several issues with a sign in log I created for work.
Problem 1. We need to open the master file and auto date Cell B1 with current date with overwrite protection if file is reopened at a later date.
Problem 2. Once the file is renamed with the current daily file name from above we need the new workbook to be auto saved every 5 minutes while it is opened.
Problem 3. On Close for the workbook to be saved before closing.
I have tried to patch this code from other codes I have made and some from other posts. I have the code working except for these 3 issues. Any help would be appreciated greatly !!
This is code from ThisWoorkBook.
This is the code from workbookSignIn page in workbook:
Thanks again for all the help with this.
Please forgive the code organization as I am new to this VBA.
Bookmarks