Button to record user usage
I am using a QV dashboard with 10 different users. My issue is that I want to know which of my user and when is using the dashboard. I have contacted the QV support but they say that it is not so easy to record this activity.
So I want to try doing it myself and for this reason I need your ideas. First of all I tried doing this by hiding all the sheets except bar 1. On this sheet I tried to put a button which when toggled will show all the sheets.
I assumed that I will use a macro to update an excel file on the s drive with data based on users info and so I will successfully have a record of all the users who used dashboard with their respective timings.
Please see the attached image.
Macro parse failed.Functionality was lost
Error:ActiveX component can't create object: 'Excel.Application'"
Is it really possible and is it safe to do so?
I need your sincere suggestions.
Looking forward to hear from you