ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   when I right click on a excel worksheet, I do not get the dropdow. (https://www.excelbanter.com/excel-discussion-misc-queries/33650-when-i-right-click-excel-worksheet-i-do-not-get-dropdow.html)

Nbhatt

when I right click on a excel worksheet, I do not get the dropdow.
 
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.

Bob Phillips

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.

--
HTH

Bob Phillips

"Nbhatt" wrote in message
...
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.




Norman Jones


Hi Bob,

I think you have a small typo

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


should be:

Application.Commandbars("Cell").Enabled


--
Regards,
Norman



"Bob Phillips" wrote in message
...
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.

--
HTH

Bob Phillips

"Nbhatt" wrote in message
...
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.






Norman Jones

And just to prove that typos are contagious:

Application.Commandbars("Cell").Enabled


S/be

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

---
Regards,
Norman



"Norman Jones" wrote in message
...

Hi Bob,

I think you have a small typo

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


should be:

Application.Commandbars("Cell").Enabled


--
Regards,
Norman



"Bob Phillips" wrote in message
...
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.

--
HTH

Bob Phillips

"Nbhatt" wrote in message
...
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.








Bob Phillips

Thanks Norman, too many options with the differing CBs ;-(

Bob

"Norman Jones" wrote in message
...
And just to prove that typos are contagious:

Application.Commandbars("Cell").Enabled


S/be

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

---
Regards,
Norman



"Norman Jones" wrote in message
...

Hi Bob,

I think you have a small typo

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


should be:

Application.Commandbars("Cell").Enabled


--
Regards,
Norman



"Bob Phillips" wrote in message
...
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.

--
HTH

Bob Phillips

"Nbhatt" wrote in message
...
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.










All times are GMT +1. The time now is 03:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com