vba code to get User id or User name who unprotects worksheet

[prabhuduraraj09]

hi friends,

as always i would need possible help from you guy i

i have a workbook, in which worksheet is protected. i want to record or to maintain a log whoever unprotects the worksheet.

i want user id or user name who is applying password to unprotecct the worksheet. i want this log in same workbook or to have it another separate workbook, either way is fine.

guys help me please!

[HaHoBe]

Hi, prabhuduraraj09,

AFAIR there is no event to be raised when a sheet is protected or unprotected, you would need to add that into the code you use (and that won´t cover the manual alteration).

Ciao,
Holger

[prabhuduraraj09]

hi HaHoBe ,

Thank you for your Quick response. i am not sure how far it is possible.
i dont want any changes to be tracked by the user. Just nee the User id to be recorded who is unprotecting the workbook.
or some logic like "the user id who is making changes after unprotecting ".

any sample work that you can provide would be much appreciated.

rest i may try..........

[HaHoBe]

Hi, prabhuduraraj09,

what will happen if the user of the workbook starts the workbook without enabled macros? That´s exactly the part where a macro based solution could fail.

i am not sure how far it is possible.

Depending on the version of Office you use you may not only need to use VBA but XML as well to stop users from unportecting worksheets without code.

Ciao,
Holger

[prabhuduraraj09]

Hi HaHoBe,

The workbook has already a macro for autosave. Users has been informed to have the macro enabled always since users use the same workbook whole day.
So that wont be a problem.

Version used is 2003.

I dont want to stop user....from unprotecting the workbook. I want to know if the user unprotecting the workbook, if yes which users are doing so.