Refer to a control name from another sheet

  • Thread starter Thread starter rezafloyd
  • Start date Start date
R

rezafloyd

Dear experts,
I embed a command button on sheet1 on a an excel workbook.
I'd like to change it's 'enabled' property at run time from a code in
sheet2.
How can I refer to it's name? (ex. 'worksheets(1).commandbutton.enabled
=false' doesn't work)
Regards,
reza
 
Sure it's called "commandbutton" ?

This works for me:

'This is on Worksheets(2)
Private Sub CommandButton1_Click()
Worksheets(1).CommandButton1.Enabled = False
End Sub

NickHK
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Possible to refer to a sheet's object name ? 10
move data w/o blank data to another sheet 1
Reference a workbook level named variable. 8
How to reference a cell from anther workbook without opening it 0
How do l get the sheet name from the sheet code name? 6
Compare 2 excel sheets -Error Checking of entered names 1
Unhide sheet, copy and rename new sheets from list, rehide sheet 8
copying cell comment from one sheet to another 2

Back
Top