Description:
I have developed a work book where in there are two sheets A & B. sheet B is linked with Sheet A i.e. values of sheet B are updated based on any change in sheet A and this is being done by a Sheet Activation Macro defined for Sheet B and every thing works perfectly.
Problem:
Now I have protected my MACRO (VBA code) by applying password. and I protected Sheet B as well through password. But after protecting the sheet B, MACRO is not working on activation.
Can anyone guide me to fix this problem.
Bookmarks