125 questions
2
votes
1
answer
97
views
Opening Animation Pane in PowerPoint with condition via VBA
The following code opens Animation Pane in Power Point Application.
Application.CommandBars.FindControl(Id:=730, Type:=1).Execute
I want to open Animation Pane if Animation Pane is not already open.
- 389
1
vote
1
answer
710
views
How to get VBE CommandBars Control ID number list
The following code is taken from this link.
https://forum.ozgrid.com/forum/index.php?thread/32040-minimize-vba-window-with-code/
Sub Macro1()
Dim cbcTemp As CommandBarControl
On Error Resume ...
- 389
0
votes
1
answer
251
views
Excel VBA - Remove slicer right click menu options
I would like to remove options from the menu that pops up when you right click a slicer.
More specifically, I would like to remove "Remove", "Cut", "Refresh", the two ...
- 1
0
votes
3
answers
943
views
Hiding Command Bar Right Click Options
I am trying to hide most of the application.Commandbar options when a user right clicks.
Usually it works but sometimes I get a debug error.
I originally managed to get it working with the below:
...
- 129
0
votes
2
answers
654
views
Hide Command Button in Word When Printing
I have a Word document with a series of of command buttons that toggle their corresponding rows of text between hidden and unhidden. I would like for the buttons themselves to be hidden when I print ...
0
votes
1
answer
387
views
Adding 'icon only' buttons to a custom context menu
Using Office 2019, Excel
How can I add 'icon only' buttons to a custom context?
I have this simple menu:
On Error Resume Next
CommandBars("MyBar").Delete
Dim cb As CommandBar
Set cb = ...
- 51
0
votes
0
answers
132
views
command bar "workbook tabs" how to do to pick automatically
With my macro im using about 300 files. I want to do the summary of all these files in one file. I have the array formula to sum some staff. I just write a formula without opening each of the file. ...
0
votes
1
answer
485
views
CommandBar Buttons Hover
I am using the CommandBar Component to display links. (The buttons are href links).
I want to remove the underline from buttons when hover. Is it possible? enter image description here
https://...
- 3
1
vote
1
answer
389
views
UWP CommandBar moves vertically when IsOpen changes
I have come across a layout / template problem with CommandBar of which symptoms are seen in several pages:
UWP - CommandBar blank space under Buttons
https://github.com/microsoft/microsoft-ui-xaml/...
- 1,254
0
votes
2
answers
783
views
Word CommandBars.ExecuteMso ("FileNew")
I am using the following command in Word VBA but in the latest version of Word 365 (version 2005):
Application.CommandBars.ExecuteMso ("FileNew")
but this does not give the same Backstage ...
- 11
0
votes
0
answers
169
views
How to find control button that was clicked inside submenu
I have menu with submenu made of control buttons:
Set MenuItem = .Controls.Add(Type:=msoControlPopup)
With MenuItem
.caption = "Code Type"
With .Controls.Add(Type:=msoControlButton)
....
- 7,034
5
votes
2
answers
392
views
Accessing CommandBarButton.Picture property the late bound way
I try to read the information of Microsoft Access (Office) CommandBars contained in an *.mdb. I could use Microsoft.Office.Interop.Access for this; however, these PIA assemblies are tied to specific ...
1
vote
2
answers
1k
views
Powerpoint - VBA - Run Application CommandBars
I want to create a macro which allows, once an object is selected, to open the associated CommandBar.
I wrote the following which works sometimes, but not everytime - it does not work the first time. ...
- 51
0
votes
1
answer
265
views
Recommended approach to display Dropdown in CommandBar
What is recommended approach to display a Dropdown in CommandBar?
There is no build-in support to display a dropdown in CommandBar. I know two ways to work around that.
Label + Dropdown. It's the ...
- 7,096
0
votes
1
answer
280
views
How to have multiple sections in Command Bar like Photos app
I am trying to replicate the appearance of the CommandBar within the build in Photos app. The command bar has three sections at the left, centre and right.
My guess is that the right items are the ...
- 4,359
0
votes
0
answers
288
views
How to arrange buttons vertically on Excel CommandBar?
My code creates 2 buttons on a custom Commandbar. It's working fine, but the 2 buttons are side by side, and I want them vertically stacked. How can I fix this ?
Sub Crea_Menu()
With ...
- 25.4k
0
votes
1
answer
1k
views
VBA: Custom Right Click Menu Option Isn't Visible
I am trying to create an option that allows the user to remove data validation from a cell via the right click menu option. So far, the code is compiling and executing without errors. It is ...
- 25
0
votes
2
answers
168
views
Commandbar not getting focus -- gotta use keyboard
My little project is progressing well, however I'm stumbling over something which is probably stupid...
Somehow, when I open the application, nothing gets focus, I have to use the "tab" key to be ...
- 382
1
vote
2
answers
907
views
UWP CommandBar Binding
is it possible to bind an UWP CommandBar to something like a ObservableCollection or so?
What i want to achieve ist to bind my CommandBar of my NavigationView to an Object of a specific Page so that ...
- 117
1
vote
2
answers
584
views
UWP Commandbar to right side
I want to move the CommandBar to the right side and let the AppBarButtons flow from top to down. In other words I want to rotate the CommandBar by 90 degrees from top to the right side of the Page
...
- 87
0
votes
1
answer
231
views
Hiding the ellipse button in command bar
I am trying to show the ellipse button in the command bar only when it is in a Minimal mode.
So far, the command bar isn't showing the ellipse button when on launched, this is how it looks like:
So ...
- 275
2
votes
1
answer
317
views
UWP CommandBar back and forward button not showing
I am developing a UWP application. I want to have a command bar with a back and forward button to help users navigate back and fore. However, the UI did not turn out what I am trying to achieve.
...
- 275
0
votes
1
answer
2k
views
How do I get the UI Fabric Command Bar contextual Menu to work?
I have been trying to use the Office UI Fabric's Command Bar control in Office.js API Microsoft Word application.
The buttons that are seen in the main bar all work as intended when the app is ...
- 55
4
votes
1
answer
1k
views
How to display a SearchBox in CommandBar
I would like to add a AutoSuggestBox in the CommandBar. However the following code does not make the AutoSuggestBox stretch. I tried setting the HorizontalContentAlignment="Stretch" and ...
- 1,554
1
vote
2
answers
628
views
Scrollbar is overlapping command bar in UWP
Ok, so scrollbar from my Hub (I think) is overlapping my command bar and it is impossible to interact with thee. So how do I disable it (the scollbar)? To get it invisible? I tried adding "...
- 874