Dear members,
I have a userform used to populate the cells of a template worksheet. This has left me with two problems I cant solve.
First I would like to be able to hide the form and check the filled template. If I do this though I cant get the form back which I need to do to use a button to file the completed template. I f I work round this by say having a button on the sheet to unhide the form then of course when it appears it is empty. Is there a way round this?
My second problem concerns the filing. I wish only to save the newly filled template as a new file name. I have only succeeded in filing the filled template together with the userform and all associated code. Idealy I would like to file the completed sheet as a workbook with only this one sheet. Is this possible? and if so how can I do it.
John
Bookmarks