Stumped for ideas - anyone any thoughts?

mplees

Active Member
Joined
Feb 6, 2006
Messages
351
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
 

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
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

Active Member
Joined
Feb 6, 2006
Messages
351
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
 

Forum statistics

Threads
1,141,727
Messages
5,708,127
Members
421,548
Latest member
douae

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top