Data Validation Protection Macro - stops working when spreadsheet is protected

Hi,

I am currently working on a project which requires a document to be "fool prove". I need to protect the data validation sections of the spreadsheet, preventing users from pasting invalid content and also breaking the DV functionality. I want users to be able to paste (disabling copy and paste is not an option).

I am using the below code which works fine until I protect the spreadsheet (DV sections are "unlocked"). Somehow the protection disables the visual basic code and allows users to paste again.

Any ideas?

Please Login or Register  to view this content.

Good morning Rookie11

Welcome to the forum!!

John Walkenbach has an elegant solution to this problem, with an article describing how it works and what it won't deal with.

http://spreadsheetpage.com/index.php...s_not_deleted/

Oh yes, and you'll never make a workbook fool-proof. There are too many fools on this planet who, with one click of a mouse, can f*** things up beyond your wildest expectations. That's what back-ups are for.

HTH

DominicB

Hi.
Thanks for the link. I have found it before and it does solve the problem of protecting the DV for unprotected sheets. However once I protect the worksheet the macro stops working and you can paste in the restricted area again.


You are probably right though, there will never be a 'fool proof' version but I don't want to give up just yet .