Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by marsderj
-
Protect/Unprotect in excel
Thanks. I did get that code to work on a new worksheet. I guess the issue that a user would still be able to paste over a data validation cell even with the sheet protected. My hope was the I could give a user the worksheet and they would not be able to paste over my data validation cells...- marsderj
- Post #5
- Forum: Microsoft VBA - Visual Basic for Applications
-
Protect/Unprotect in excel
Still no luck. I am not sure that its just not my version of excel. It is as if it is not even protecting the sheet when I use the protect method. Have you used the code successfully?- marsderj
- Post #3
- Forum: Microsoft VBA - Visual Basic for Applications
-
Protect/Unprotect in excel
I am fairly new to the VBA world, so any assistance would be greatly appreciated! I have a worksheet which is intended for user input and contains a specific column with data validation drop down lists. I have code that prevents the user from pasting into this specific column and forces them to...- marsderj
- Thread
- Replies: 5
- Forum: Microsoft VBA - Visual Basic for Applications
