ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Right Click menu doesn't appear in Page Break View (https://www.excelbanter.com/excel-programming/404716-right-click-menu-doesnt-appear-page-break-view.html)

ExcelMonkey

Right Click menu doesn't appear in Page Break View
 
I remember discussing this a while back in this forum. I have built a right
click menu which works fine when I am in Normal View. What can I do to
enusure that my menu works during the Page Break View? Currently it does not
load while in this view. Here is part of the code I use. Does it revolve
around making this more dynamic?

Set ctrl = Application.CommandBars("Cell").Controls.Add _
(Type:=msoControlPopup, Befo=5)
ctrl.Caption = "Other Utilites..."
ctrl.BeginGroup = True

Thanks

EM


All times are GMT +1. The time now is 08:57 AM.

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