Allowing Marcos To Run in a Protected Sheet

How do I allow macros to run when users click check boxes without making it possible for them to change the formulas in certain cells? Even with the Unprotect method as the first line in the subroutine, the sub does not get accessed at all as long as the sheet is protected. The check boxes themselves are unlocked, and I have also tried unlocking the cells where the check boxes reside.

You could do this by having a userform appear when the sheet gets activated - Additionally, on your worksheet that is protected, unprotect the cells that need to have data input allowed in them. Technically, the check boxes will not be enabled if the underlying cells are protected. Suggestion would be to arrange all the check boxes on a range of unprotected cells and then have the appropriate code run according to the selection made.

CA Vikram S Mathur

I found this little nugget here in this forum that works without specifying details for each work sheet. Copy the following code into your Workbook page with "Workbook" and "Open" listed in your drop down tabs in VBA. Sorry that I cannot remember to whom the credit goes.

Please Login or Register  to view this content.

K Rose