Can't right click

[Anthony]

Help !!

for some reson two of my macros's attached to two pics in my worksheet have
'dropped out' and the right click has been somehow disabled so I can't edit
the pics so that I can reattach them.
The worksheet is full of various bits of VB code (most of which has been
donated from here) so I don't even know where to start looking in the VB
editor for the potential problem.

Anybody any ideas to help, or what to look for in the code??

many thanks

[Dave Peterson]

Is the worksheet protected?

--

Dave Peterson

[Anthony]

Hi Dave,
no it isn't

[Gord Dibben]

Anthony

Possible the sheet is protected which would disable the right-click on the
picture unless you had "edit objects" checked when protecting.

Does the right-click menu pop up when you right-click on a cell or column/row?

Gord Dibben MS Excel MVP

[Anthony]

Gord,
The sheets(s) are not protected, and no, the right click menu doesn't show
if I right click anywhere !
uuummmm

[Dave Peterson]

Does it only happen in that one worksheet? Only one workbook?

What happens if you start excel in safe mode:

close excel
windows start button|Run
excel /safe

file|open your workbook and test it out.

--

Dave Peterson

[Anthony]

Dave,
Clever!
opened the worksheet as suggested in safe mode (never new that exsisted) and
the right click works fine. Can I adjust things and then save the file for
use in normal mode??
Cheers

[Gord Dibben]

Anthony

Sounds like code disabled the Cell right-click menu.

Run this macro.

Sub reset()
Application.CommandBars("Cell").Enabled = True
End Sub

How about if you right-click on a sheet tab?

If sheet tab r-click is also disabled you need

Sub reset()
Application.CommandBars("Plyl").Enabled = True
End Sub

I would also be looking at any workbooks or add-ins that may have code running
to disable the right-click menu if it occurs again.

Gord

[Chip Pearson]

> Application.CommandBars("Plyl").Enabled = True

Should be "Ply" not "Plyl".

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

"Gord Dibben" <gorddibbATshawDOTca> wrote in message
news:g5i2t15oi8tgcdmb3...@4ax.com...

[Gord Dibben]

Typo patrol!

Thanks for the correction Chip

Gord

On Fri, 20 Jan 2006 14:47:37 -0600, "Chip Pearson" <ch...@cpearson.com> wrote:

>> Application.CommandBars("Plyl").Enabled = True
>
>Should be "Ply" not "Plyl".

Gord Dibben MS Excel MVP

[Anthony]

Gord,

the code....

Sub reset()
Application.CommandBars("Cell").Enabled = True
End Sub

did the trick for normal r-click, but on running the other bit I get an
error...

Run-Time error '5' invalid procedure call or argument

..also still unable to r-click on my images, as this is what I realy want to
do so that I can adjust which macro they point to.

thanks this far

[Anthony]

Chip,
thanks - that's the tabs sorted, any ideas why I can't right click on my
images?

[Dave Peterson]

It might be easier to just kill all the toolbars (reset to factory defaults).

if you want to try:

close excel
windows start button|search
look for *.xlb
and rename all you find to *.xlbOLD

restart excel and test it out

You'll have to rebuild any custom changes you've made.

===
If it doesn't work, just rename the *.xlbOLD back to *.xlb (you may have to
delete any new *.xlb before you rename the old)

--

Dave Peterson

[Anthony]

ummm - this could be to much work for something simple,
I'll have a think about that Dave, but many thanks for your suggestions
kind regards

[Dave Peterson]

It shouldn't take more than 5 minutes to do it, test it, and reverse it if it
failed.

--

Dave Peterson