Is there a way to track/log users who open an excel file and also keep it very hidden? Thanks.
Is there a way to track/log users who open an excel file and also keep it very hidden? Thanks.
Last edited by maacmaac; 11-24-2010 at 12:57 PM.
Hi
I am not sure what you need exactly, but you can use the workbook open and close events to achieve what I think you need.
With workbook close hide all sheets that you do not want visible and save before close.
With workbook open re-hide (in case of disabling vba or crashes), call custom form for password verification, unhide if password correct, log users. Can be as simple or detailed as necessary (e.g limit attempts).
Regards
Jeff
If it's on a server, you could use the file auditing features in Windows. If you use VBA you are reliant on people enabling macros when they open it.
Remember what the dormouse said
Feed your head
As romperstomper says, this is reliant on macros being enabled on opening
Please Login or Register to view this content.
To view the sheet enter this in the Immediate pane of the VBa editor
Press ReturnPlease Login or Register to view this content.
When you have finished viewing the log either enter this in the Immediate pane
Press ReturnPlease Login or Register to view this content.
or just close the file.
If you need any more information, please feel free to ask.
However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....
Also
اس کی مدد کرتا ہے اگر
شکریہ کہنے کے لئے سٹار کلک کریں
If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.
That works great but I forgot that some of the users will have read only access to the file. I still want to log users that are trying to access the file but I need a way to save the data in the log file. Is there a way to save the file in read-only access? I tried to modify the code to save but keep getting a run-time error. ThanksPlease Login or Register to view this content.
No, you will have to write to another file in that case.
Thanks for tip. I think I can actually do a work around in which users can open without having to use read only. I will most likely add protection within the workbook and would still be able to accomplish what I need. Thanks.
Thanks for this code--it's the perfect solution for something that I've been asked to do!
Last edited by sandywinkelman; 03-24-2011 at 09:42 AM.
Hi,
I'm also looking for a solution for the same issue that Sandy wanted. If I want to maintain this log in a seperate excel, how this code should be amended?
Thanks.
Logasai welcome to the forum
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.
If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.
Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
When my workbook opens, i set it to send an email to me automatically, is this something that would work for you?
Hi Wayneg,
There are several users who work with this workbook daily. So I don't think e-mail notification would be a good solution as my main purpose is to know the exact person who has opened the workbook so I or the user can check with that person and do any changes to the workbook. As the number of users are high, it's really painful when someone opens it keep without closing for a long time and if anyone wanted to work with the workbook, that person need to goo around the team ans aks who opened the excel...
I've been using this code with great success in my classes, but there is one problem that keeps cropping up. When a student uses a Mac, most of the data aside from date and time is blank. Can anyone advise on how to make the code expose Mac user data as well?
rlmeyers welcome to the forum
Perhaps you missed my post #10?
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.
If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.
Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
hi wayneg, could you please show me how to do this?
Administrative Note:
Welcome to the forum.
We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.
Please see Forum Rule #4 about hijacking and start a new thread for your query.
If you are not familiar with how to start a new thread see the FAQ: How to start a new thread
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks