MSB <markbrdsly <at> tiscali.co.uk> writes: > > > Forgive me if this is a stupid question but what order are you doing the > operations in? Are you adding the validation and then protecting the sheet > or protecting the sheet and then adding the validation? > > I have no idea if it matters at all but it could be that, if you are > protecting the sheet and then adding the validation, that this is the source > of the problem. > > Yours > > Mark B
You are right, if I apply protection to the sheet after adding data validation all works well. Funny, this should be documented! :) Thanks! --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
