when I right click on a excel worksheet, I do not get the dropdow.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Has anyone had a problem with displaying the dropdown menu containing
Edit|Paste|etc in the worksheet. I have a user who has this problem. I have
remove and re-installed Office to no avail.
 
Maybe you have some code disabling it.

Try entering

Application.Commandbars("Cell").Visible = True

on the VBIDE immediate window (Ctrl-G). If that brings it back, search for
some similar code in your start-up workbooks.
 
Hi Bob,

I think you have a small typo
Application.Commandbars("Cell").Visible = True

should be:

Application.Commandbars("Cell").Enabled
 
And just to prove that typos are contagious:
Application.Commandbars("Cell").Enabled

S/be

Application.Commandbars("Cell").Enabled =True
 
Thanks Norman, too many options with the differing CBs ;-(

Bob
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top