Re: Autonew

The equivalent macro name in Excel is Auto_Open.

--
Jim
"parkin_m" <parkinm@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:7F150E0E-9502-46C7-B0A9-85723707A7C1@xxxxxxxxxxxxxxxx
|I have a excel document which contains a template for an invoice.
|
| I am going to create a userform in excell which will show itself whenever
a
| new document is created, allowing the user to pick a client name and then
| select an address which will then populate the excel document.
|
| I have done this before using word where i did:
|
| (in autonew macro)
| userform1.show
|
| (in userform1 form)
| //do vba code to enter information
|
| I tried to do this using excell but autonew macro doesnt seem to self
| execute like in word. Is there a simple solution?
|
| Thanks


.

Relevant Pages

  • Re: Getting source lists w/o opening target file
    ... This macro returns a the list of files that the document is linked do (it ... Probably depending on how the link was created. ... >> We need a method to extract the list of documents an excel document is ...
    (microsoft.public.excel.programming)
  • Re: Mail merge Word/Excel Dilaogue/Database Engine error
    ... I did understand those basic parts, but the Macro parts are way too deep. ... "Peter Jamieson" wrote: ... the Excel document might be very large ... the user opens the document (is that just using Word ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Overwriting a file in VB
    ... >>> run the macro it asks me to overwrite the files and I would like it ... I'm actually using VB script inside an Excel document. ... VBA, actually. ...
    (microsoft.public.vb.syntax)
  • Excel 97 document and a possible macro
    ... We have an excel document that is viewed by at times by multiple users. ... spreadsheet to be updated via a scheduled task. ... With word the /m macroname commandline option made word run the macro upon ... option does not seem to be in the excel startup options, ...
    (microsoft.public.office.misc)
  • Re: Reading Layout View
    ... original AutoOpen macro with only the reading layout line and another ... one with all the options (called AutoOpen2). ... I've realized that my problem goes beyond the Reading Layout view ... then you also need that line in an AutoNew macro - again at its ...
    (microsoft.public.word.docmanagement)