I am trying to create a macro to select all sheets in active workbook and copy them into a new book (Named "Copy.xls") that doesn't contain the macros and buttons in the original used to launch the macro. Any quick way to do this?
At the least, I would like to know how to write code to select all sheets. THANKS!
This message was edited by Cosmos75 on 2002-04-08 12:03
At the least, I would like to know how to write code to select all sheets. THANKS!
This message was edited by Cosmos75 on 2002-04-08 12:03