Edit Range of a protected worksheet
Hi
Is it possible to have a defined range to be chosen for allowing users to edit rather than a definite range. 'Allow Users to Edit Ranges' [Tools = Protect]. For example enter the function =indirect({Defined Name}) where the defined name changes based on the data entry made by users. This is very useful in the case of protected worksheets with forms to be filled up by users. Regards SnJ |
All times are GMT +1. The time now is 02:41 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com