How to save a hidden excel sheet to a separate file?

Question

Macros

You need to save one of the sheets of the book in csv format to a separate file. The macro should be triggered when the document is saved. The problem is that you need to save the hidden sheet.
If you use this solution:

With Worksheets("ИмяЛиста")
        .Visible = -1    ' делаем лист видимым
        .Copy    ' копируем 
        .Visible = 0    ' делаем лист снова скрытым
 End With

then everything works, but at the time of saving the file, the hidden sheet is shown to the user for a while. A kind of blinking of a leaf. Somehow not aesthetically pleasing and not very clear to the user what is happening.
Question: is it possible somehow completely imperceptibly for the user to copy information from a hidden sheet to a csv file?

Answer 1

at the beginning of the macro
application.screenupdating = false
and at the end
application.screenupdating = true
This will help to hide the flicker and the user will not see the sheet.

Answer 2

Nothing breaks for you, just products are displayed immediately according to the two specified filters.