BartH
New Member
- Joined
- Jul 4, 2006
- Messages
- 14
Hi group,
In the VBEditor environment, I have some customizations to the commands in the command bars.
Sometimes errors cause all changes to be reset, so I decided to put some code together to make the changes programmatically.
Now there are some strange results and I am looking for answers, I hope you might be able to provide:
Grtz Bart
In the VBEditor environment, I have some customizations to the commands in the command bars.
Sometimes errors cause all changes to be reset, so I decided to put some code together to make the changes programmatically.
Now there are some strange results and I am looking for answers, I hope you might be able to provide:
- when adding the Compile command
VBA Code:Application.VBE.CommandBars("Standard").Controls.Add 1, 578
while when adding it manually, the result is:
Why the difference, and why doesn't Compile All &Modules do anything?
- When I add a default control
VBA Code:Application.VBE.CommandBars("Debug") .Controls.Add msoButtonIcon, 579, , 3
VBA Code:Application.VBE.CommandBars("Debug") .Controls(6).FaceId = 9724
- Where are changes to the VBE command bars stored and could they be restored when stored and re-applied?
I found some reports of them being stored in the registry and also it would be in a xlb (xlsb now?) file.
What is modern truth and coherence here?
Grtz Bart