Save only certains worksheets

[MariaPap]

Hello

I have a big workbook with many(50) workshhets and almost 100 userforms.

In one of these userforms for security reasons i use the code

ThisWorkbook.Save
at the end of my whole code.

As the book is very big it's takes much time, so as i need (in fact) to save only the data of certain 2 sheets, i think that i'll reduse the time saving only these 2 sheets.

Any idea how to do it?

Thnks in advance for any idea.

[davsth]

What is the purpose of saving the sheets? They can be exported to a new workbook and saved, which would be much smaller. However do links need preserving and is the data needed in your master workbook.

If it is needed in your master workbook (or does it refresh each time it is run, so you don't need to save it?)

[MariaPap]

Thanks for your reply

I save eatch time that specific code, runs, because i need to be sure that in any case, i would not loose data that i tranfered.

That's why i asked to save only 2 sheets, after specific code is runing.