Export dialogsheets as forms

  • Thread starter Thread starter Scott
  • Start date Start date
S

Scott

Any ideas how one can "move" or "export" userforms which
were created as part of the workbook (an actual worksheet
in the workbook) with a previous version of Excel?

Several worksheets in the book are userforms that I would
like to bring into the Project Browser...WITHOUT having
to recreate each one (a couple of the forms have numerous
controls on them). Currently they are not even visible
in the Project Browser - even as one of the worksheets -
because I believe they were designated as dialogsheets
when they were originally created.

I have tried selecting the form, copying and then pasting
it into a blank form in the browser - however nothing
will paste. I can select, copy and paste controls on the
exisitng form, but I can't paste them into a new form.

I was hoping there would be a way to 'export'
and 'import'. Any suggestions?...Anyone?
 
Dialogsheets are not userforms. Totally different.

You should be able to copy them like any other sheet in a workbook.

Make the sheets visible, then use Edit=>Move or copy sheet


You can copy any associated code by copying it as text and pasting it into a
general module.

The will still be dialog sheets - no userforms.


You have received a suggestion on how you might convert them.

Regards,
Tom Ogilvy
 
Andy,
Thanks for the info! It worked. What a tremendous help.

I was actually surfing around his site last night but
apparently quit just before trying the link you
suggested. The wizard is fantastic! I still have some
work ahead of me, but at least I don't have the re-layout
everything.

Thanks again!
Scott
 
I still have some
work ahead of me, but at least I don't have the re-layout
everything.
Click to expand...


You might have said a mouthful. Converting the physical appearance may seem
trivial if your code is at all involved.

Regards,
Tom Ogilvy
 
Back
Top