Userform with template class module problem

  • Thread starter Thread starter Jim C.
  • Start date Start date
J

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.
 
Perhaps the workbook_Open event in the thisworkbook module.

Regards,
Tom Ogilvy

Jim C. said:
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
=---
 
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

Jim C. said:
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:

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.
 
Back
Top