Disable button in VBA for Excel 2011

[ksignorini]

I'm trying to disable a button in Excel 2011 using VBA. It doesn't seem to work. Apparently VBA for Excel 2010 (Windows) also had this bug.

One solution I've found was to remove the macro from the button and grey out the text on the button to make it look disabled, then when I need it enabled again, re-hook-up the macro and change the text colour back. Again, this doesn't work (the macro switching works but not the greying out).

Here's how I've done the disabling that originally didn't work:

Please Login or Register  to view this content.

Here's how I've tried to grey out the text on the button which also didn't work:

Please Login or Register  to view this content.

Any ideas how to make this work in Excel 2011 VBA? I've had to resort to .Visible = False and I hate it. I want to see the button, just disable it.

Thanks so much!

[Blokeman]

Try;

Please Login or Register  to view this content.

[LJMetzger]

Hi ksignorini and Welcome to ExcelForum,

Thank you for using CODE TAGS. It is much appreciated.

A technique that works for me is to have two buttons superimposed on top of each other. Which Button is displayed can be controlled by either:
a. Making One Button Visible and One Button Not Visible
b. The Zorder Command which determines Which Button is on Top

For more information on Zorder Enumerations see: https://msdn.microsoft.com/zh-cn/lib...ice.11%29.aspx

This avoids having to play with the OnAction text.

See the attached sample workbook and the code that follows:

Please Login or Register  to view this content.

Lewis

[ksignorini]

@Blokeman - Unfortunately, this doesn't seem to work either. Perhaps because I'm using 2011 for Mac?

[ksignorini]

Hi ksignorini and Welcome to ExcelForum,

Thank you for using CODE TAGS. It is much appreciated.

A technique that works for me is to have two buttons superimposed on top of each other. Which Button is displayed can be controlled by either:

Lewis - Thanks for the examples. I'll see if I can make this work.