Sheet access monitoring

  • Thread starter Thread starter AliquiGuido
  • Start date Start date
A

AliquiGuido

Is there a way I can identify if a user goes to tools> protection >
unprotect or protect.
What I want to be able to see is if a user has gone and unprotected a
sheet made a change and then re-protect the sheet??...is there a way
of performing this check??? Any ideas?
 
perhaps you could use a class module to isolate the event associated with sheet protection. No idea how you would do this though!
 
Why don't you compare worksheet against a master worksheet to determine if
anything has changed?
 
You could also use Track Changes if you just want to monitor changes. You can protect the workbook for sharing with tracked changes which prevents the change history from being removed.
If you want to prevent them, protect the sheet with a password.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do you Determine if a Worksheet is protected? 2
Spell Checking on a protected sheet 1
Returned position address on protected sheet 7
Protecting & Unportecting the sheet. 5
Protecting sheet in a macro doesn't work 1
Copying in sheet with protection with the use of a macro 5
Sharing workbook removes cell protection 1
Protecting worksheet. 1

Back
Top