ScottyBee
03-22-2021, 04:56 PM
I have an Excel workbook that has a column for each user, roughly 12 total. When the user opens the workbook, I have code in the Open event that retrieves their username and hides all columns except that of the current user.
When coding this project, I learned that simply opening up the VBE editor in another workbook and typing application.enableEvents = False allows me to open the workbook in question and bypass the code in the Open event. This means that someone who knows a little programming could do the same and view the hours for all the users.
Fortunately, the data shown is not proprietary or sensitive. I was just tasked with a means of creating an "easy" way for each user to see his/her training related hours.
If this was sensitive data, Is there a better method to accomplish this task that does not involve using a web based or SQL Server solution? Thanks for your advice. :)
When coding this project, I learned that simply opening up the VBE editor in another workbook and typing application.enableEvents = False allows me to open the workbook in question and bypass the code in the Open event. This means that someone who knows a little programming could do the same and view the hours for all the users.
Fortunately, the data shown is not proprietary or sensitive. I was just tasked with a means of creating an "easy" way for each user to see his/her training related hours.
If this was sensitive data, Is there a better method to accomplish this task that does not involve using a web based or SQL Server solution? Thanks for your advice. :)