2 Things, CommandBars & Windows
 

Hello, I've got a problem, well, 2 problems or things I don't know how
to do, but I think them are rather simple.

One of them, I've got one WorkBook, and to do some things I create new
Windows of this WorkBook, and so, on the Windows OS taskbar appear as
many Excel instances as new windows I create like Workbook:1,
Workbook:2, and so on.
I need to have only one instance on the TaskBar, even I have more than
one window of the WorbBook open. I think this should be posible.
Any help on this?

The second thing I am looking for is an automatic way of formating the
Command Bars of Excel, with some macros with the purpose of using the
WorkBook.
I have looked to some literature and searched the web, and now I know
how to create a new CommandBar if it does not exist, and also I know
how to add to it buttons, but the problem is that I don't know which is
the VBA code to assign a macro to each button.

Well, those are the things that I need to deliver the app in the most
fashioned way I am able to do VBA nowaday to my client. Any help would
be very appreciated, thanks!!


--
baldomero
------------------------------------------------------------------------
baldomero's Profile: http://www.excelforum.com/member.php...o&userid=25680
View this thread: http://www.excelforum.com/showthread...hreadid=465880

2 Things, CommandBars & Windows
 

Tools=Options=View Tab, in the show section, uncheck Windows in taskbar


use the OnAction property of the command bar button.

mybutton.OnAction = "mymacro"

--
Regards,
Tom Ogilvy


"baldomero" wrote
in message ...

Hello, I've got a problem, well, 2 problems or things I don't know how
to do, but I think them are rather simple.

One of them, I've got one WorkBook, and to do some things I create new
Windows of this WorkBook, and so, on the Windows OS taskbar appear as
many Excel instances as new windows I create like Workbook:1,
Workbook:2, and so on.
I need to have only one instance on the TaskBar, even I have more than
one window of the WorbBook open. I think this should be posible.
Any help on this?

The second thing I am looking for is an automatic way of formating the
Command Bars of Excel, with some macros with the purpose of using the
WorkBook.
I have looked to some literature and searched the web, and now I know
how to create a new CommandBar if it does not exist, and also I know
how to add to it buttons, but the problem is that I don't know which is
the VBA code to assign a macro to each button.

Well, those are the things that I need to deliver the app in the most
fashioned way I am able to do VBA nowaday to my client. Any help would
be very appreciated, thanks!!


--
baldomero
------------------------------------------------------------------------
baldomero's Profile:
http://www.excelforum.com/member.php...o&userid=25680
View this thread: http://www.excelforum.com/showthread...hreadid=465880