Can't right click embedded objects

[Nick_F]

I have a strange problem where I cannot right click any embedded
objects to bring up the context menu e.g. in order to access the
properties and changed linked cells etc...

The book still does what it is meant to do i.e. buttons still accept
left mouse clicks and scroll bars still work etc...

I tried an earlier version of the spreadsheet and it still works fine.
If I create new sheets with embedded objects they work fine but if I
copy the object into the affected book I cannot right click. Yet I can
copy a single object to a new sheet and it works fine but not multiple
objects.

Clearly it is a setting somewhere but I don't recall making changes
anywhere either by clicking or code. The sheets and book are
unprotected.

Any Ideas?

Nick

 

[Peter T]

If these are Active-x controls from the Control toolbox toolbar, on that
toolbar click the 'Design mode', normally the top left icon. You should then
be able to select and right click your ole's. Don't forget to Exit Design
mode when done.

Regards,
Peter T

 

[Nick_F]

Wish it was that simple but no I didn't make that rookie mistake ;-)