2 Things, CommandBars & Windows

[baldomero]

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!!

[Tom Ogilvy]

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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>