Hide Show Command Buttons
 

I am hiding a command button(s) with the following statement

CommandButton1.Visible = False

I then need to display all of the buttons on the page. I had tried:

Application.CommandBars("Control Toolbox").Controls("&Design Mode").Execute
CommandButton1.Visible = True

But that didn't work.

Thanks in advance for any help.

Hide Show Command Buttons
 

See this page for a example

http://www.rondebruin.nl/controlsobjectsworksheet.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Troubled User" wrote in message ...
I am hiding a command button(s) with the following statement

CommandButton1.Visible = False

I then need to display all of the buttons on the page. I had tried:

Application.CommandBars("Control Toolbox").Controls("&Design Mode").Execute
CommandButton1.Visible = True

But that didn't work.

Thanks in advance for any help.