I have created a userform for data entry and would like to protect the data entered from the sheet so it forces the user to use the edit cmd button I have in place and be unable to delete rows or manually change data. Is there anyway to do this?
I have created a userform for data entry and would like to protect the data entered from the sheet so it forces the user to use the edit cmd button I have in place and be unable to delete rows or manually change data. Is there anyway to do this?
Have you tried protecting the worksheet ?
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Yes, protecting the worksheet gives runtime errors in VBA saying I need to unlock the sheet to make changes.
Putat the top of your code andPlease Login or Register to view this content.
at the end of your code.Please Login or Register to view this content.
In workbook open using
Sheets("name of sheet").protect "pas",userInterfaceonly := true
"ThankyouFor Attention * And Your Help!!"
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
Run in worksheet_activate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks