00:00Would you like to keep track of who had made changes to your spreadsheet?
00:03Well, in my previous video, we tracked changes made of what, where, and when.
00:07Now, let's integrate accountability as requested by one of my viewers like yourself.
00:12We're going to start off by adding a new column called By in your log sheet.
00:15Then after that, you're going to right-click on the sheet name and go View Code.
00:19I have another video explaining in great detail of how this BBA script works.
00:23If you need the link to that video, please leave a request on the comment section.
00:27Now, to keep track of who had made changes to the spreadsheet, you're going to add a new line here.
00:32You're going to copy the one above and paste it right below.
00:35Make sure you change this to 7.
00:37And then you're going to say value equal application username.
00:40And after that, press Ctrl-S to save.
00:42And let's close the BBA editor.
00:44Now, every time you make any changes to your spreadsheet, you can see that the username up here is here,
00:49which is pertaining to this username on your spreadsheet.
00:52If you do need a copy of this BBA script, please leave a request on the comment section.
00:57of the video.
Comments