Excel 2007 VBA: Determine if worksheet was unprotected

**Hudas** · 11-04-2012, 04:41 PM

Hi -

Is there a way to determine if a protected worksheet was unprotected?

Thank you

**jeffreybrown** · 11-04-2012, 04:51 PM

How would they unprotect if they could? Do they know the password?

I'm asking this because I believe there could be different ways to answer.

**Hudas** · 11-05-2012, 09:58 AM

Lets just say, they have the means to know the password. I want to have a hidden sheet that tracks if a sheet was unprotected then protected... they can't change the password because I have a vba(Password Protected) that runs for that template that let them edit a cell and locks it after editing.

**jeffreybrown** · 11-05-2012, 12:05 PM

A hidden sheet capturing the fact whether a sheet is unprotected and then reprotected is probably the way to do, but not sure you can capture this attribute through using the ribbon.

At least for me, the way to do it would be through an inputbox. Doing it this way will allow you to have some value written to the hidden sheet when the code is fired.