Show/hide text Boxes on several sheets by running a macro

[mlcfexcel]

Dear all,

I want associate a vba code to a button in order to show/hide several text boxes in different sheets on the same workbook.

I have already been able to toggle a text box ("ClosingLabel") on the active sheet but yet not able do do so on other sheets.
The code for that in as follows:

Please Login or Register  to view this content.

I would appreciate your precious help!
Regards,
Manuel

[LJMetzger]

Hi mlcfexcel,

Try the following (tested and working using Excel 2003):

Please Login or Register  to view this content.

Lewis

[mlcfexcel]

Thank you Lewis!
But I am looking for something different. I trying to activate/deactivate text box in other sheets by running a macro on a specific sheet. Would you have a suggestion for this problem?

Cheers
Manuel

[LJMetzger]

Hi Manuel,

My code toggles the shape "ClosingLabel" in all Sheets. It doesn't matter what Sheet the Macro is called from. If you're still having problems, please upload a sample file with 2 or 3 sheets, because we probably aren't understanding each other.

Lewis

[mlcfexcel]

My mistake. You're completely right! The macro works perfectly.
Thank you again Lewis.
Regards,
Manuel