Stumped for ideas - anyone any thoughts?

[mplees]

Hi all,

I'm trying (in more ways than one!) to create a workbook that does the following:

1. Make a new entry on one of 4 sheets, depending on whether the entry is to log an audit, calibration, non-conformance or equipment failure event (I think I can do this through a user form, & by pasting the data into the next blank row).
2. Once the log entry is entered, open up a corresponding sheet which will be used as the detail form. I need this form to be hidden until called, & I then need to save this form as a single sheet (this I'm having problems with - I cant figure how to keep it hidden, call it & then ensure that the original is hidden again with no data - in effect, this sheet needs to act as a template)

I'm totally at a loss as to how to deal with the second part, & I apologise if my explanation isn't very clear - my brain just isn't in gear today!

Hope someone can steer me in the right direction,

Regards,

Mark

 

[Andrew Poulsom]

Why don't you save the single sheet as a template (.xlt) file? In VBA you can open a copy like this:

Workbooks.Add Template:= "PathToTemplate"

replacing PathToTemplate with the actual path and name. Saving that workbook won't disturb the original.

 

[mplees]

Hi Andrew,

Many thanks for your input. I was hoping to be able to keep this as a self contained workbook, but I suppose that having some external templates wouldn't really matter.

Thanks for the idea - I'll give that a go!

Regards,

Mark