Nigel,

Use

Sheets(1).OLEObjects("cbTotals").Enabled = True



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Nigel" wrote in message
...
Hi Guys
I have not used ActiveX controls on a sheet before, so any help
gratefully
received.

I have a worksheet with some activeX command buttons, each are
set manually
using the control properties to enabled = false.

In my VBA code module I am trying to use the following to
enable the
controls, in this case the command name is cbTotals, however
this does not
work :-(

Sheets(1).OLEObjects("cbTotals").Object.Enabled = True

Something simple I'm sure but I've tried various permutations
without
success

Cheers
Nigel