Hide or unhide sheets

Hi there,

I have a code that erase data in a sheet, but the sheet is hidden. the code work well when the sheet is visible, but I dont want it to be visible. How can I make add to the code to unhide the sheet, clear all the data, and hide it again? no password is needed.

my code:

Please Login or Register  to view this content.

best regards,

Jakes

Assuming your sheet is "Hsheet" Use this changed code.

Please Login or Register  to view this content.

Thanks a lot! have a great day!