How to run a Macro on Password Protected xl sheet veryhidden

[RAJESH1960]

Hi. The command button is in an active sheet, But it has to select data from a xl sheet very hidden in the same workbook. It showed an error when I tried to use the command button. How do I run the macro without un-protecting my sheet.

 

[RAJESH1960]

Hi. The command button is in an active sheet, But it has to select data from a xl sheet very hidden in the same workbook. It showed an error when I tried to use the command button. How do I run the macro without un-protecting my sheet.
View attachment 17878

The macro runs perfectly without the protection. When I run the macro it copies the data from the very hidden xl sheet to be pasted and saved. I also do not want the code to be seen when error is debug.

 

[Joe4]

How do I run the macro without un-protecting my sheet.

You don't. What you do is have the Macro temporarily unprotect it, do its work, and then re-protect it.
So it is only unprotected for the very brief time while the macro is running (and with no user interaction).

You can see how to do that here: Unprotect sheet error in VBA

 

[RAJESH1960]

Hello Joe4. Thanks for the response . I got the solution.
Sheets("Sheet1").Activate

ActiveSheet.Unprotect "Hello"

‘Get the clipboard data

strData = .GetText

Sheets("Sheet1").Activate

ActiveSheet.Protect "Hello"

 

[Joe4]

You are welcome.