Mouseless navigation10/6/2023 ![]() No editing of the hardware is necessary.Īll decks and samplers have a full DJ effects section, all controlable/selectable by the rotaries on the UC-33e.īUT - the best bit is the mouseless navigation. This is based on Factory Preset 1 on the UC-33e. It has 3 DJ-Channels (3 "Decks") and a 4th Channel that contains 4圆 slot samplers (all samples are triggerable from the UC-33e numpad). The sample workbook has the modified right-click menus, the navigation form and a button in the Developer tab to start the form.I've created a Live Template for use with the UC-33e. This functionality uses VBA from my last post, which raises an event every time any chart in a workbook is selected. The form is modeless and responds to selection changes in the workbook, updating the list selection when you click into a different pivot or chart. Use the Ctrl key with the left and right arrows to toggle between a pivot and its associated chart. ![]() Selecting an item in the form list takes you to the selected pivot. The form opens up with a list of all the pivot tables in the active workbook. The other element of the sample workbook is a simple-yet-powerful form that navigates through a workbook’s pivot tables and pivot charts. If 1.Address(external:= True) = (external:= True) Then The code to go to a pivot table’s chart loops through all chart sheets and charts on worksheets looking for one whose source range is the pivot table’s range:įunction GetPivotChart(pvt As Excel.PivotTable) As Excel.Chart That’s one thing I like about programming the ribbon: the code to show or hide tabs, buttons and other controls is generally simpler than it is when using VBA. I use this same property in the RibbonInvalidate method to only show the “Go To Pivot Table” button when the chart is a pivot chart. It looks at the charts PivotLayout property, which only exists if a chart is based on a pivot table. The code to go to the source pivot is similar to that in my Finding a Pivot Chart’s Pivot Table post. Since I’m already forced to use XML to modify the chart context menu, I used it for the pivot table context menu too, even though it can still be modified with VBA: All of this, including links to the Custom UI Editor and the NameX addin, is covered very nicely in this MSDN post. I also used the Microsoft’s NameX addin to figure out the name that refers to the chart context menu (ContextMenuChartArea) The XML for the chart and pivot table context menus is below. To create the button I used the Custom UI Editor and added a ContextMenu section to the XML. I’d never used Ribbon XML to make a right-click menu before. This impression was confirmed in a Jon Peltier post, so I know it’s true.Īs mentioned above, I’ve added a “Go to Source Pivot” button at the bottom of the chart context menu. It seemed that, unless I’d just gotten much less picky (not likely), pivot charts work much better than I remembered. Recently though I was given a project that contained many pivot charts. I used to eschew pivot charts as far too clunky. The downloadable workbook can be easily converted to an addin. I used Ribbon XML for this last part since later versions of Excel don’t allow modification of the chart context menus with VBA. These buttons take you to the associated pivot chart or table. ![]() The workbook also adds buttons to the chart and pivot table right-click menus. ![]() The sample workbook contains a Pivot Table and Pivot Chart Navigator userform that lists the workbook’s pivot tables and takes you to them or their associated charts. This post is about navigating between pivot tables and pivot charts.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |