Userform with template class module problem

[Jim C.]

I am having trouble calling a userform for my personal workbook from
the class module of a new sheet generated from a template.

I can get the form to work from the original template, but when I
generate a new instance of the sheet, the call to the userform
generates an error.

Any ideas?

Thanks in advance

Jim C.

 

[Jim Cordner]

Sorry:

The templae is in my Personal Workbook
Using Excel 97

Regards,

Jim C.

 

[Tom Ogilvy]

Perhaps the workbook_Open event in the thisworkbook module.

Regards,
Tom Ogilvy

Tom:

Thanks for your suggestion, I went with the export / import idea.

I would like the userform to load as soon as the new instance of the
template is formed but so far all I can seem to do is wait for the
user to change something on the sheet ( using the change event ) or
activating the sheet ( activate event ).

Can you suggest a way to trigger the userform export / import similar
to the "new event" in word templates?

Regards,

Jim C.






----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption

=---

 

[Tom Ogilvy]

to add, you might want to check if the workbook has a path

if thisworkbook.Path <> "" then
' this is not a new workbook so jump out
End If

Regards,
Tom Ogilvy

Tom:

Thanks for your suggestion, I went with the export / import idea.

I would like the userform to load as soon as the new instance of the
template is formed but so far all I can seem to do is wait for the
user to change something on the sheet ( using the change event ) or
activating the sheet ( activate event ).

Can you suggest a way to trigger the userform export / import similar
to the "new event" in word templates?

Regards,

Jim C.






----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption

=---

 

[Jim C.]

Tom:

When I insert a template will an auto_open event in that workbook be
launched? I thought that it would only launch on opening the
workbook.

Regards,

Jim C.