View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default Place TextBox Behind Other Controls on a Workshheet

In design mode right click the control and look at Order.

Adapted from the macro recorder -

ActiveSheet.Shapes("Label1").ZOrder msoSendToBack

Regards,
Peter T

"Minitman" wrote in message
...
Greetings,

I am using a TextBox as a back ground. I have done this in a UserForm
to color a MultiPage control by setting the display orderSend to back
or Bring to front with ZOrder. I don't see that command available for
a Control Toolbox Label.

Can anyone show me how to put this Control Toolbox Label behind other
controls (CommandButtons)???

Any help will be appreciated.

-Minitman