Problem with shapes on protected sheets

[ikolins]

Dear experts,

I am trying to solve the problem with multilingual functionality for macro enabled excel model. In order to change language options for Form Control buttons, I have written the following code:

Please Login or Register  to view this content.

Unfortunately code doesn't work correctly on protected sheets neither with unprotect/ protect options nor UserInterFaceOnly options.
Have been working around the shapes and formatting issues, but didn't find the solution.

Is there any solution for that?

Thanks a lot!

[ikolins]

Thank you for the notice. I have attached the sample workbook.
The problem is that Multilanguage function, which I have described with the following simple code, doesn't work correctly on protected Sheet1 neither with unprotect/ protect options nor UserInterFaceOnly options:

Please Login or Register  to view this content.

Is there any solution for that?

Thanks a lot!

[davesexcel]

You can unprotect the sheet first. password is 1234

Please Login or Register  to view this content.

[ikolins]

Thanks a lot! As always - the simplest solution is the best.

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.