I have sheet that is designed for end users to only be able to put information in unlocked cells. I want them to then be able to click the corresponding the button that puts this information into a master sheet. THEY ARE NOT TO BE ABLE to edit any sheets or any buttons. I have around 200 different buttons.How do I keep the workbook protected, but still allow the end users to click buttons?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
How to keep buttons functional in a protected sheet
sijpie
Well-known Member
- Joined
- Nov 1, 2008
- Messages
- 4,269
- Office Version
- 365
- Platform
- Windows
- MacOS
wberg82, don't fully understand the question. Are you saying
1. the buttons can't be pressed when the sheet is protected, or
2. the macros don't work when the sheets are protected?
1. When I have a sheet with simple form buttons, they keep working when the sheet is protected
2. there are two options, either in your code unprotect then after the changes protect again, or use the UserInterfaceOnly option.
you can read more about this on this link: http://codevba.com/excel/protect_worksheet.htm#.XKUQJCgzZ3g
1. the buttons can't be pressed when the sheet is protected, or
2. the macros don't work when the sheets are protected?
1. When I have a sheet with simple form buttons, they keep working when the sheet is protected
2. there are two options, either in your code unprotect then after the changes protect again, or use the UserInterfaceOnly option.
you can read more about this on this link: http://codevba.com/excel/protect_worksheet.htm#.XKUQJCgzZ3g
Upvote
0
Similar threads
- Question
