Thread: [Solved] popup cell menu not working when in table
View Single Post
 
Old 11-20-2018, 06:48 PM
trevorc trevorc is offline Windows 7 32bit Office 2013
Competent Performer
  
Join Date: Jan 2017
Posts: 173
trevorc will become famous soon enoughtrevorc will become famous soon enough
Default
Found it, I needed to address the list range popup (table) not the cell popup.

Code:
Set ctlNewMenu = Application.CommandBars("List Range Popup").Controls.Add(Type:=msoControlPopup)
Reply With Quote