button in excel 1

[smiley0q0]

how do i make a cmd button not be visible in code?

 

[nickjar2]

cmdButton.visible = false

Nick

 

[smiley0q0]

i tried that, and it gives me the error

"Run Time Error '424':"

"Object Required"

 

[nickjar2]

Are you placing the code in the sheet that the button is.
Ie. if button is on sheet1, is the code also in sheet1?

Nick

 

[smiley0q0]

no, it's in a module, but i have selected the sheet that it is in.

 

[nickjar2]

What is your line of code?

 

[smiley0q0]

i want to make it not visible once it has been clicked, but when the worksheet is opened again i want it to be visible. when you asked if the code was in the sheet that the button was in, i put it in there after my call statement, like this

Private Sub CmdUpdate_Click()
Call Filter
CmdUpdate.Visible = False
End Sub
now that works fine. (filter is the macro in the module)

now i don't know where to put the code to have it be visible when the workbook opens

it gives me an error if i try this in the sheet that the button is in...

Private Sub Workbook_Open()
CmdUpdate.Visible = True
End Sub

Thank you for your help.

Smiley B-)

 

[nickjar2]

I can't seem to work this out. If no-one else responds to this tonite, I will take a look at work tomorrow.
You say:
"now i don't know where to put the code to have it be visible when the workbook opens"
Does the workbook get closed at some point? The when the workbook gets reopened, make the button visible again?

Nick

 

[JVFriederick]

The only way I know of is the hide them all, then use a Alt key combination to turn them back on.

ActiveWorkbook.DisplayDrawingObjects = xlHide

This probably isn't much help, but it's all I could think of.

 

[nickjar2]

Private Sub Workbook_Open()
sheet1.CmdUpdate.Visible = True
End Sub

Where sheet1 id the name of the sheet where your cmdUpdate button is.

Could u let me know if this works please? It has worked fine on my pc.

Nick

 

[smiley0q0]

Nick,
that works perfectly!!!
That deserves a star :-D

Thank you.

Smiley B-)

 

[office97]

Maybe one you can help me.
Im having problems correctly troubleshooting for greyed out option buttons that are located along the top bar when in print preview in office 97. If you have any Ideas beside uninstalling and reinstalling please let me know.

Thanks
Syd.