Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
using vba in excel 2003
can someone help i want to input data into a worksheet 3 columns, first a ref
no, second a name, third a surname. Save sheet. When open new sheet require the first ref no to be added auto but +1 and so on for further sheets. -- BD3 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
using vba in excel 2003
Sounds like you would need code in the workbook to enforce this (assuming
that the user doesn't disable macros or the security setting disables them). See Chip Pearson's page on events http://www.cpearson.com/excel/events.htm -- Regards, Tom Ogilvy "bigdaddy3" wrote in message ... can someone help i want to input data into a worksheet 3 columns, first a ref no, second a name, third a surname. Save sheet. When open new sheet require the first ref no to be added auto but +1 and so on for further sheets. -- BD3 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 versus Excel 2003 & Excel 97-2003 fully compatible | Excel Worksheet Functions | |||
Convert Excel 2003 spreadsheet into Outlook Contacts table 2003 | Excel Discussion (Misc queries) | |||
import Excel 2003 file into Outlook 2003 - NO NAMED RANGES?? | Excel Discussion (Misc queries) | |||
Copying Excel 2003 Selection into Outlook 2003 HTML E-Mail Message | Excel Discussion (Misc queries) | |||
Excel 2003 Database Driver Visual FoxPro 7 on Server 2003. | Excel Discussion (Misc queries) |