Juriemagic
06-23-2015, 03:32 AM
Hi good and clever people!..
I am working on a maintenance program for hotels and would like VBA to log certain info. There are also other functionality I require, which is:
1). When sheet "Update rooms" is activated, and NO changes to this sheet is made, (Maybe just viewing), the user must be able to close the sheet at any time
2). If changes are made, even just one change, this sheet cannot be exited unless a button "Submit", had been clicked.
3). Upon clicking submit, The date, time and username must be logged to a protected sheet, called "Logs".
4). The logging starts in A3:C3
5). Any future logging will log underneath the last entry.
I am sure this might be a lengthy one, but I am really in a mud pool with this one, as I do not have a single clue on how to remotely even achieve this. All and any help will be accepted with the utmost of appreciation and respect. Thank you all kindly..
I am working on a maintenance program for hotels and would like VBA to log certain info. There are also other functionality I require, which is:
1). When sheet "Update rooms" is activated, and NO changes to this sheet is made, (Maybe just viewing), the user must be able to close the sheet at any time
2). If changes are made, even just one change, this sheet cannot be exited unless a button "Submit", had been clicked.
3). Upon clicking submit, The date, time and username must be logged to a protected sheet, called "Logs".
4). The logging starts in A3:C3
5). Any future logging will log underneath the last entry.
I am sure this might be a lengthy one, but I am really in a mud pool with this one, as I do not have a single clue on how to remotely even achieve this. All and any help will be accepted with the utmost of appreciation and respect. Thank you all kindly..