Auto run macro on File->New->Template

**owainl** · 08-04-2008, 05:23 AM

Hi,

Just quickly - I'm trying to make a template that displays a form when a user first creates a new file from it. At the moment, the macro that I'm using runs the form whenever the document is opened:

Please Login or Register  to view this content.

Thanks,

Owain

**owainl** · 08-04-2008, 10:02 AM

OK, so I've been reading about this and it now seems I should be using the following:

Please Login or Register  to view this content.

Still need help making it run only once though.

**owainl** · 08-06-2008, 04:40 AM

Bump-a-rooney

**royUK** · 08-06-2008, 04:52 AM

That code will display the form on opening. You need the form & relevant code in the workbook then save it as a template (*.xlt) See

http://www.excel-it.com/excel_templates.htm

If you don't want it to show you would need to store some check in an inaccessible place, on a hidden sheet perhaps.

Please Login or Register  to view this content.

**owainl** · 08-06-2008, 11:40 AM

Cheers - smart thinking! The option I actually went for (which has now been sent out to the whole of my department, making all this a bit academic) was to have the module that loads the form delete itself afterwards. The only disadvantage of this method is that it requires users to allow Programmatic Access to VBA, thereby exposing them to a risk of virus.

I'll bear this better version in mind though and add it to the next update.

Thanks again!

Auto run macro on File->New->Template

LinkBack

Thread Tools

Rate This Thread

Display

Auto run macro on File->New->Template

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions