Hi.
I'm new to writing Macros so require some assistance. A previous colleague was pretty ace at doing these, so I've written similar coding to the previous sheet he had used.
I've written the code out now, but an error keeps popping up, and it;s regarding making some buttons visible/invisible. I've typed out;
sheets("PO Form").button14.visible = true
sheets("po form").button16.visible=false
Button 14 is the one thats come up with an error, saying 'object doesn't support this property or method' - i've no clue what this means...if someone can put this into plain English, it will be very helpful (or even recomend a code to use to make buttons visible/invisible)
Thank you!
I'm new to writing Macros so require some assistance. A previous colleague was pretty ace at doing these, so I've written similar coding to the previous sheet he had used.
I've written the code out now, but an error keeps popping up, and it;s regarding making some buttons visible/invisible. I've typed out;
sheets("PO Form").button14.visible = true
sheets("po form").button16.visible=false
Button 14 is the one thats come up with an error, saying 'object doesn't support this property or method' - i've no clue what this means...if someone can put this into plain English, it will be very helpful (or even recomend a code to use to make buttons visible/invisible)
Thank you!