LinkBack URL
About LinkBacks
CYO 
Just saying that you can't delete or copy in a warning message doesn't prevent it happening.
Why not lock the cells and protect the worksheet with the appropriate (default) options selected?
Just saying that you can't delete or copy in a warning message doesn't prevent it happening.
Why not lock the cells and protect the worksheet with the appropriate (default) options selected?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
The warning message was just a "nice to have", it's the looking up of the list on the hidden sheet, I hoped would prevent them from changing the data, but it doesn't seem to always work. Locking the cells doesn't give staff the option to highlight the data in the cells and then copy it over. The data in my mock-up sheet is probably too simple - my real data, has a much longer string and it's important to be kept in the format eg. no spelling errors or spaces added (to allow the import of data).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks