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 |
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 |
All times are GMT +1. The time now is 03:27 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com