I don't know if this is possible, but is there a way to get Excel to trigger a macro whenever a user either protects or unprotects a certain worksheet within a workbook via Protect/Unprotect Sheet.
Ideally, I would like to be able to trigger one macro if the worksheet is protected and a separate second macro if the worksheet is unprotected.
An added complication is that this will need to work in both Excel 2003 and Excel 2007/2010.
Is this doable?
Many thanks in anticipation of any help.
Chris
Ideally, I would like to be able to trigger one macro if the worksheet is protected and a separate second macro if the worksheet is unprotected.
An added complication is that this will need to work in both Excel 2003 and Excel 2007/2010.
Is this doable?
Many thanks in anticipation of any help.
Chris
