ActiveSheet.Shapes("MyShape").ControlFormat.Enable d = False

--
Regards,
Tom Ogilvy


"0000_AAAA_0000" wrote in
message ...

Sorry!
I think I did not ask properly!
I need to disable a Shape, keep it just to make nicer a worksheet


I would like:

'This does not work because MyShape is actually a Shape
ActiveSheet.OLEObjects("MyShape").Enabled = false

'This Does not work and is what I do pretend to
ActiveSheet.Shapes("MyShape").Enabled = False


--
0000_AAAA_0000
------------------------------------------------------------------------
0000_AAAA_0000's Profile:
http://www.excelforum.com/member.php...o&userid=12480
View this thread: http://www.excelforum.com/showthread...hreadid=273633