Thanks Bill. I have never thought of the hide feature in Excel. I learned
something.

"Bill Renaud" wrote:

<<...how do I hide the Workbook A?

I use Excel 2000, so I use the Window|Hide command. It may now be in a
different menu for you, if you are using Excel 2007.

<<I will have both Workbooks A and B opened in the same Excel window.

This is normal. Workbook A (macros) will be hidden. Workbook B (data) will
be visible.

<<I will have a command button in one of the worksheets in Workbook A...

No. If you are using Excel 2007 (which now has ribbons instead of
CommandBars), you will have to figure out how to add a custom toolbar to
the Excel environment, so you can place your button on this toolbar and
attach it to Workbook A.

<<...when I click on the button, it will execute the macro in Workbook B.

You mean the macro (in Workbook A) will process the DATA in Workbook B.
There is NO macro in Workbook B!

<<I won't be able to use the code "Workbooks ("Workbook B").Activate"
because the Workbook B name will be variable.

True. This is why you set a reference to the ActiveWorkbook almost the very
first thing in your macro, as I suggested in my previous post.

--
Regards,
Bill Renaud