Re: Autonew

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

AutoNew is the name of the MSWord macro.

In excel, you can use Auto_Open (in a general module) or Workbook_Open (in the
ThisWorkbook module).



parkin_m wrote:

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

--

Dave Peterson
.

Relevant Pages

  • Re: Creating multiple worksheets...
    ... Stick this macro into a general module in your workbook. ... File>Save then Alt + q to return to Excel. ... Paste #1 onto new worksheet - repeat for each additional worksheet) Is this ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Creating multiple worksheets...
    ... Stick this macro into a general module in your workbook. ... File>Save then Alt + q to return to Excel. ... Paste #1 onto new worksheet - repeat for each additional worksheet) Is this ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Creating multiple worksheets...
    ... Stick this macro into a general module in your workbook. ... File>Save then Alt + q to return to Excel. ... Paste #1 onto new worksheet - repeat for each additional worksheet) Is this ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Auto-execute an Excel macro upon opening .xls file
    ... To run from a general module you must rename to ... Sub Auto_Open ... Gord Dibben MS Excel MVP ... I'm trying to set a macro to auto-fire upon opening. ...
    (microsoft.public.excel)
  • Re: VBA: For Count, when count changes from cell to cell
    ... with Excel 2000. ... reporting Macro being unavailable. ... Sub CalculateI3() ... means that you can refer to it in a cell just like a built-in Excel function. ...
    (microsoft.public.excel.misc)