Hi all,
Brand new to this forum, but not to Excel. I've been coding VBA for many years.
An app that I created 7 or 8 years ago does a lot of manipulation of the commandbar controls, including hiding and/or disabling many of the items on built in commandbars and adding custom items to those commandbars.
When the user opens the file macros run to remove certain commands and add some custom commands, and when they close it I restore the default commandbars by doing a reset.
But now that we have 2007, running this code 'hides' the ribbons and creates the old builtin commandbars (file, edit, view, Window, Help) with some default commands removed, and some custom commands added. Now when the codes does a reset, it removes the commandbars but does not restore the ribbons.
I haven't been able to find much that will help me with this ... has anyone here seen this, or have any insight on how to work with the ribbons from within the VBA code?
Brand new to this forum, but not to Excel. I've been coding VBA for many years.
An app that I created 7 or 8 years ago does a lot of manipulation of the commandbar controls, including hiding and/or disabling many of the items on built in commandbars and adding custom items to those commandbars.
When the user opens the file macros run to remove certain commands and add some custom commands, and when they close it I restore the default commandbars by doing a reset.
But now that we have 2007, running this code 'hides' the ribbons and creates the old builtin commandbars (file, edit, view, Window, Help) with some default commands removed, and some custom commands added. Now when the codes does a reset, it removes the commandbars but does not restore the ribbons.
I haven't been able to find much that will help me with this ... has anyone here seen this, or have any insight on how to work with the ribbons from within the VBA code?
