Refer to command button on Excel sheet from form 1

[MDA]

HI all,

I am trying to enable a command button on an Excel sheet from a form...

I can use:
Sheet1.cmdOpen.enabled = true

However, I need to copy this code to several workbooks so I do not want to refer to a sheet number, rather the name of the sheet.

Thanks for any help...

Regards,

Mike

 

[rmikesmith]

Hi Mike,

Try this:

ThisWorkbook.Worksheets("YourSheetName").cmdOpen.Enabled = True

HTH
Mike