How to enable macros with protected worksheet

[Kevalin O]

I have been trapped for hours of how to enable macros with protected worksheet.

Any suggestion please?

I did try to put UserInterFaceOnly on the vba code of that worksheet. But it still not working when I protected the worksheet.

Please Login or Register  to view this content.

Thank you very much in advance

[Winon]

Hello Kevalin,


At the beginning of your Code add this line:

Please Login or Register  to view this content.

And at the end of the Code protect the sheet again:

Please Login or Register  to view this content.

Regards

[Kevalin O]

Thank you for your suggestion Winon.
I am very new to this. I wrote down this code that allows me to select multiple options from a drop down list.
From the code that you gave me. I tried to add it at the beginning and at the end, but it kept saying error.
If you don't mind helping me by showing where should I add your code in, I would be very much appreciated. Thanks again heaps

Please Login or Register  to view this content.

[Fotis1991]

@ Kevalin O

Welcome to the forum

Pls

Use code tags around code.

Posting code between tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here


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

[Winon]

Hello Kevalin,

Please try it like this,

Please Login or Register  to view this content.

[HaHoBe]

Hi, Winon,

I would recommend to have a look at the protect command you supplied (wrong command UserInterFace, you must either use the names for all or use commata to separate the parameters) and move the commands regarding Protection, ScreenUpdating as well as Enable behind the jump mark for the error handler. Itīs not really good to unprotect a sheet, detect an error in the code and leave the sheet unprotected via the error handler. :

Please Login or Register  to view this content.

Ciao,
Holger

[Winon]

@ HaHoBe,

Hi Holger,

Oops!!!,

You are absolutely correct.

Thank you for correcting my mistake, my friend!

Regards