ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   commandbar control works on some computers, not others (https://www.excelbanter.com/excel-programming/438746-commandbar-control-works-some-computers-not-others.html)

Josh

commandbar control works on some computers, not others
 
I have written code to display a menu item on the right-click menu. It works
on my pc and numerous others throughout the company, but some other pc's
don't show the menu item when they right click. All of my other code is
working perfectly on all pc's, but for some reason this right click menu item
is giving me trouble. I've ruled out different versions of Office as the
problem. I am using the following set statement and then listing out the
caption, face id, etc.:

Set cBut = Application.CommandBars(39).Controls.Add(temporary :=True)

Anyone have any ideas???

JP[_4_]

commandbar control works on some computers, not others
 
Have you tried "Application.CommandBars("Cell").Controls.Add
(temporary:=True)"?

--JP

On Jan 22, 1:57*pm, josh wrote:
I have written code to display a menu item on the right-click menu. *It works
on my pc and numerous others throughout the company, but some other pc's
don't show the menu item when they right click. *All of my other code is
working perfectly on all pc's, but for some reason this right click menu item
is giving me trouble. *I've ruled out different versions of Office as the
problem. *I am using the following set statement and then listing out the
caption, face id, etc.:

Set cBut = Application.CommandBars(39).Controls.Add(temporary :=True)

Anyone have any ideas???




All times are GMT +1. The time now is 04:59 PM.

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