Hi!

In a program that has many userforms that fill in report tables for printing, the tables are not saved so they are clear on opening. There is one worksheet that records a set of data that I wish to save.

I can find no way of saving that single worksheet. The only solution I can come up with, is to save all and then run a 'select worksheet/unprotect worksheet/select range/clear content/protect worksheet' on numerous sheets.

Can anyone make a suggestion?

Many thanks