Data Forms
I'm using Excel 2003 SP2. I have a requirement to send +- 155000 records to
various external parties. I want them to add to the data which I send them, but not to modify any existing data. The spreadsheets contain 60 fields of which the first 28 should remain untouched. I have exported the data from Access and therefore all data per row is related (as in a database) I would like to have all the data in one workbook. Because of the number of records I will have to split it into 3 worksheets. I need to enforce some data capture rules for the columns I want added. I need to know whether I can use a form of some sort (I read that data forms are limited to 32 columns and therefore that is not an option) whereby users can select their own relevant records and capture required data. Can I protect the 3 worksheets which hold the data? I would appreciate any assistance, advice or comments. Thanks |
Data Forms
John Walkenbach has an enhanced data form:
http://j-walk.com/ss/dataform/index.htm And the source code is available for a small fee ($20 USA, IIRC). Maybe you could protect the worksheets (hide them, too) and allow access only through your userforms? But be aware that excel's worksheet and workbook protection isn't made for this type of thing. If the user is curious enough, he or she will be able to break your protection and do whatever he/she wants. fpc001 wrote: I'm using Excel 2003 SP2. I have a requirement to send +- 155000 records to various external parties. I want them to add to the data which I send them, but not to modify any existing data. The spreadsheets contain 60 fields of which the first 28 should remain untouched. I have exported the data from Access and therefore all data per row is related (as in a database) I would like to have all the data in one workbook. Because of the number of records I will have to split it into 3 worksheets. I need to enforce some data capture rules for the columns I want added. I need to know whether I can use a form of some sort (I read that data forms are limited to 32 columns and therefore that is not an option) whereby users can select their own relevant records and capture required data. Can I protect the 3 worksheets which hold the data? I would appreciate any assistance, advice or comments. Thanks -- Dave Peterson |
All times are GMT +1. The time now is 03:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com