Macros not working on protected worksheet

I have several worksheets in my workbook and all are protected. I use the following code on workbook open. Most of the several macros within the workbook run fine.

Please Login or Register  to view this content.

However, the following macro does not run. I have the spinner behind a rectangle (I want the spinner to be "hidden" until it is brought forward by this macro).

Please Login or Register  to view this content.

Hi there,

It seems that the ZOrder property may not be changed while the worksheet is protected.

Instead of hiding the Spinner behind a Shape, why not just toggle the Visible property of the Spinner as required? The Visible property may be changed while the worksheet remains protected.

Hope this helps - please let me know how you get on.

Regards,

Greg M

GregM,
Thank you much!!! You gave me direction and I was able to come across the following, and it works GREAT!

Please Login or Register  to view this content.

GregM,
I spoke to soon. I have several Spinners on the worksheet that are referenced to several different cells. How would I wrote the above code to have each of the "If/Else" statements?

GregM,
Duh....
I used the following code and all works good.

Please Login or Register  to view this content.

Hi again,

Many thanks for your feedback and also for the Reputation increase - much appreciated

Well done on working everything else out for yourself!

Best regards,

Greg M