Hi Manos

You can use SaveCopyAs in code to create the new file and open it with code.
Then you can use code from this page to make values of all worksheets
http://www.rondebruin.nl/values.htm

If you need a working example post back



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Manos" wrote in message ...
Dear all

There is a huge workbook which includes a big amount of sheets with fomulas
and diagrams. Also those sheets are locked with a specific password.

There is any possibility to create an add in or run a macro in order to save
this book in a folder as it is, but in all sheets to have all the data as
values, and no formulas at all.
I have try couple of things that some people tried to help me, but it gives
an error either becuase of lock sheets, or the diagrams.

So i need something in order to save the full workbook as another file with
all sheets (either hidden or not) in order for the rest of my team to open it
without to be a problem.

Thanks in advance
Manos