Access Denied: Contact Your Administrator error when running macro

Hello

I have a macro on a worksheet that runs as expected when I execute it, but when other uses try they get an Access Denied: Contact Your Administrator error. This may have happened when we upgraded from Excel 07 to 13 but I'm not certain.

Here is the VBA for the macro

Please Login or Register  to view this content.

Thanks in advance for any help!

Possible problems:

Your ResetFormEquator does not unprotect a sheet prior to executing.
Your ranges are not sheet specific. You may be unprotecting one specific sheet while trying to modify ranges in the active sheet (which could still be protected)

Thanks that was only supposed to be a single macro. Not sure how those others got in there I didn't even notice them. I have deleted the other two as they are not relevant to the current sheet. Hopefully that corrects the issue, but I won't know until tomorrow.

Ok now the users are getting this error. Seems weird as this also happens when hitting the reset button which is just supposed to run that macro.


AW.png