How to run a macro in password protected sheet

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.

The macro needs to unprotect the sheet, do its thing, and then reprotect it.

Hi,

You would either need to unprotect and protect the sheet within your code or alternatively you could protect the worksheet using VBA setting the UserInterfaceOnly parameter to True and this allows your macros to do their stuff while protecting the sheet from user interaction.

Dom

See VBE Help for Protect method

You set it like this:

Please Login or Register  to view this content.

Note the UserInterfaceOnly setting is not saved with the workbook so would need to be re-applied each time the workbook is opened. There are also certain methods like find/replace which will not work under this setting even if run from a macro.

Dom

It would be like this:

Please Login or Register  to view this content.

Dom

Have you password protected your VBA project? In the VBA editor right click on the project in the project explorer and select VBAProject Properties and then set the password on the Protection tab.

Dom

That line of code is basically saying ignore any errors that you encounter. In my opinion would be better to use a proper error handler than just blast through although there obviously are occasions when it can be used effectively.

Something like this:

Please Login or Register  to view this content.

Dom

Dear Dom, leo73pk

It seems my problem is same as urs.

So kindly help.
I want to run a procedure to update the current market prices in ONE Sheet. Also I want to hide this sheet and then protect the complete workbook.

CODE IS :

Please Login or Register  to view this content.

Regards
Anchal

Anchal,

Welcome to the forum.

2 pointers-

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. In order to put code tags, either type [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] at the end of it, OR you can highlight your code and click the # icon at the top of your post window.

Also,

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.