Hi,

Does anyone know if it's possible to turn a button placed on sheet1 to visible=False and visible=True.

What I'm trying to do is something along the lines of the below, but I can't find a way in VB to pick up control of the buttons.

Worksheets.("Sheet1").Button("Button1").visible = False

Thanks

probably best to ask this in the Excel forum....

Hi,

Does anyone know if it's possible to turn a button placed on sheet1 to visible=False and visible=True.

What I'm trying to do is something along the lines of the below, but I can't find a way in VB to pick up control of the buttons.

Worksheets.("Sheet1").Button("Button1").visible = False

Thanks

What do you want to achieve? The code is correctly formatted, but on its own it will not do anything.

I have 3 buttons on an excel page (Sheet1). The buttons are named Button1, Button2, Button3.

My ideal starting point would be to make button2, and button3 invisible from the starting point.

Button1 is a submit button. When pressed I would like the submit button to be hidden, and Button1, and Button2 to become visible.

No matter what I try, I'm just getting messages 'Object doesn't support this property or message".

I actually don't care how it's done - The buttons could be made invisible; greyed out; shrunk in size; not even present to start with and then created as part of the command behind button1...

The long winded solution I have at the moment is to put if commands behind button1 and 2 stating that if the current windows user, is the same user who pressed submit, then do nothing... (There's a hidden audit sheet which tracks who pressed submit).

Are you using form buttons or ActiveX buttons? I think that you will only be able to use VBA to control their status with the latter.

The Worksheet class does not have a Button property which is why you get that error. As weejas said, the correct answer depends on what type of buttons they are (ActiveX vs Forms) - but both can be made hidden via VBA. Tell use which type they are and we can show you how to do it!

duplicate thread:
VB Buttons in Excel

threads merged

Only duplicate because you asked me to post it in the excel forum, and then moved the 1st one after I posted the 2nd!

Thanks for your help everyone. I'll consider using ActiveX buttons but it might be easier just to put my if condition in the subs. At least I know now that the route I was trying was a dead-end.

It wasn't a dead end!

As I said, you can do it with either forms controls or activeX controls: we were just waiting for you to clarify which you are using so we could show you the correct approach.

not quite true

I made the posting about Excel and moved the thread at the same time.....
but who cares, ultimately you got the answer you needed (I hope)

Thanks all; I revisited this and found that it's a lot simpler than expected;

In that case you are using Forms controls.