View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
XP XP is offline
external usenet poster
 
Posts: 389
Default Custom tab available to all open workbooks?


Thanks Ron; I was thinking this might work; I will delve into this and see
what happens.

Thanks!

"Ron de Bruin" wrote:

Oops

In the open and close events and not the Activate and Deactivate events

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Ron de Bruin" wrote in message ...
Hi XP

You can create a add-in with your Ribbon.

And in the Activate and Deactivate event in the thisworkbook module
of your normal workbook open and close the add-in with code



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"XP" wrote in message ...
Using Windows XP with Office 2007;

I need a way to create a custom tab on the ribbon that will be visible and
usable to all open workbooks, until the file containing the code for the
custom tab is closed.

Is there a way to do this? If so, can I get some instructions on how to
accomplish this?

Thanks!