making a button invisible

[Goh]

is it possible to make a button in an excel spreadseet to become invisible from vb6 after calling out the excel template?

[agmorgan]

Try this. In my case it hides the Paste button.

MsgBox Application.CommandBars("Standard").Controls(10).Caption
    Application.CommandBars("Standard").Controls(10).Visible = False

You would need to iterate through the controls until the Caption matched the one you were looking for
Then set it to false.

[scostell]

Be carefull though, you'll need to set the button visibility back to true when exiting or it won't show up next time you open Excel. Unless that is your desired effect.

[Goh]

sorrie...i make a wrong statement...
the button which i mention comes from the control toolboxin excel (commandbutton1 for eg)...tha t is paste on the sheet.....trying to make it invisible..

[RobDog888]

I posted the answer in your VBA Forum thread.