Enable change only with Form?
I am using a UserForm to populate fields in a worksheet. The user fills in
the fields in the Form and clicks the Enter Data button; the information is then transferred to the next available row in the sheet. I'd like to protect the data from being able to be changed unless the user opens a separate Edit Data Form. What would be the best way to accomplish this? Through the SheetChange event? Some setting of protection? What would you recommend? Ed |
Enable change only with Form?
when you write the data, unprotect the sheet, unlock the cells, write the
data, lock the cells, protect the sheet. -- Regards, Tom Ogilvy "Ed" wrote in message ... I am using a UserForm to populate fields in a worksheet. The user fills in the fields in the Form and clicks the Enter Data button; the information is then transferred to the next available row in the sheet. I'd like to protect the data from being able to be changed unless the user opens a separate Edit Data Form. What would be the best way to accomplish this? Through the SheetChange event? Some setting of protection? What would you recommend? Ed |
Enable change only with Form?
Since data entry is made only through the form, would it make sense and save
steps to unprotect and unlock in Form_Initialize, and lock and protect on Terminate? Or are there reasons I would want to do it on each data line entry? Ed "Tom Ogilvy" wrote in message ... when you write the data, unprotect the sheet, unlock the cells, write the data, lock the cells, protect the sheet. -- Regards, Tom Ogilvy "Ed" wrote in message ... I am using a UserForm to populate fields in a worksheet. The user fills in the fields in the Form and clicks the Enter Data button; the information is then transferred to the next available row in the sheet. I'd like to protect the data from being able to be changed unless the user opens a separate Edit Data Form. What would be the best way to accomplish this? Through the SheetChange event? Some setting of protection? What would you recommend? Ed |
All times are GMT +1. The time now is 05:18 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com