Excel 2007 : How to save just one sheet from an excel wok book

Hello.

I have a question.

I have a workbook that contains 2 sheets. Sheet 2 is my help sheet where I have about 500 articles to pick from.
Sheet 1 is where I have dropdown menus where I can pick articles from sheet 2.
Sheet 1 is a sheet where I have an order for suppliers.

My problem is when I make an order on sheet 1. I want to send this file to the supplier but when I send the file I don't want the supplier to see all the articles. So what I want to do is save just Sheet 1 in another file and lock it so the supplier can't change my order and can't see all the other articles I have in my help sheet.

Does anyone understand what I mean?

Please help. If it's even possible to save just one sheet to another workbook.

Oh yeah...I'm using Excel 2007.

Regards, Denis

Hello,

manually:

1. right-click the order sheet tab and select "Move or Copy"
2. click the checkbox "Create a copy" and hit OK
3. select all the cells in the new sheet, copy and then use paste special - values
4. right-click the sheet tab of the new sheet, select "Move or Copy"
5. In the drop-down box at the top select "(new book)" (do not tick "Create a copy"!!)
6. This will move the new sheet to a new book. It will just have the values, no formulas, and you can save this new workbook and send it to your supplier.

cheers,

@ teylyn

I just wanted to say how much I appreciate you taking the time to help. Thank you!
Angel USAboy

manually:

1. right-click the order sheet tab and select "Move or Copy"
2. click the checkbox "Create a copy" and hit OK
3. select all the cells in the new sheet, copy and then use paste special - values
4. right-click the sheet tab of the new sheet, select "Move or Copy"
5. In the drop-down box at the top select "(new book)" (do not tick "Create a copy"!!)
6. This will move the new sheet to a new book. It will just have the values, no formulas, and you can save this new workbook and send it to your supplier.

cheers,