vote up 0 vote down
star

My company recently upgraded from Office 2003 to Office 2007. When I was working in Office 2003 I created a really useful little floating toolbar with lots of useful little tools. I can't see a way of creating a similar toolbar in Office 2007. Does anyone have any idea how I could do this?

flag

5 Answers

vote up 0 vote down

These should automatically show up in the Add-ins tab. To make it really look nice, tho, you're going to have to learn how to manipulate the ribbon. I recommend "RibbonX Customizing the Office 2007 Ribbon" by Martin, Puls, Hennig

link|flag
Does that mean the only way of adding custom toolbars / buttons etc. is either the quick links bar or the ribbon? I was hoping to have a floating toolbar, just because that is what I am used to. – Ian Turner Oct 15 at 21:12
vote up 0 vote down

The book Bob mentions is an excellent resource. You can usually find a used copy online for under $15. While you wait for it to arrive you might try:

http://gregmaxey.mvps.org/Customize_Ribbon.htm

link|flag
vote up 0 vote down

You can use the quick access bar for this functionality. It will put the commands right at the top next to the Office pearl button.

To do it, right click a command you want and choose the "Add to Quick Access Toolbar" option:

alt text

link|flag
vote up 0 vote down

Were your "lots of useful little tools" just built-in Word commands or were they macros that you wrote yourself?

Edit: You could use VSTO to create a custom task pane. There might be a bit of a learning curve if you've only worked with VBA and are moving to .NET development, but it would be worth your time to learn the new tools if you're doing any Office customization work.

Here are a couple articles to get you started:

http://msdn.microsoft.com/en-us/library/aa338197.aspx

http://msdn.microsoft.com/en-us/library/bb772082.aspx

link|flag
They were both built in commands that were normally quite well hidden and some macros. – Ian Turner Oct 16 at 5:18
Was hoping to avoid anything that complicated. I'm okay using a bit of visual basic but anything more seems a bit wasted effort on me because I don;t think I'll do much else with it. – Ian Turner Oct 27 at 21:22
vote up 0 vote down

You can pretty easily convert the toolbars that are all lumped in the add-ins tab of the ribbon to their own tab using the Custom UI software. It's not very hard to use.

http://openxmldeveloper.org/articles/customuieditor.aspx

To get a floating toolbar, you'll have to create a modeless Userform. Also not very hard to do.

link|flag

Your Answer

Get an OpenID
or

Not the answer you're looking for? Browse other questions tagged or ask your own question.