I have two workbooks. I want to delete worksheets from the one that i
not currently active. How do I do that? Right now it keeps deletin
the sheets from the active one...

Thanks!
Elieze

--
Message posted from http://www.ExcelForum.com

Make sure to refer to the workbook by name. So if the
workbook is called XYZ.xls (I'm so imaginative!), and it
is currently open:

Workbooks("XYZ").Worksheets("Sheet1").Delete

or

Workbooks("XYZ").Worksheets(1).Delete

tod

-----Original Message-----
I have two workbooks. I want to delete worksheets from
the one that is
not currently active. How do I do that? Right now it
keeps deleting
the sheets from the active one...

Thanks!
Eliezer


---
Message posted from http://www.ExcelForum.com/

.

Specify the other workbook

workbooks("otherbookname.xls").Worksheets("Sheet3" ).Delete

--
Regards,
Tom Ogilvy

"Lazer " wrote in message
...
I have two workbooks. I want to delete worksheets from the one that is
not currently active. How do I do that? Right now it keeps deleting
the sheets from the active one...

Thanks!
Eliezer


---
Message posted from http://www.ExcelForum.com/

Great - thanks!!

--
Message posted from http://www.ExcelForum.com