Allowing VBA to edit protected cells

**lucasar** · 02-06-2014, 07:49 AM

Hello everyone.
I made a sheet to control some reports, and it works like this: you click a button ("Insert"), it opens a userform, you type everything there (date, serial number, client, city) and it place that info on the first row available. Then there's a "Clear Last Entry" button, and that's it.
I would like to protect the whole sheet and only allow users to insert new entries via the "Insert" button.
How can I do this? If I protect normally Excel won't allow the VBA code to write on cells.
Thank you!

**Fotis1991** · 02-06-2014, 07:53 AM

Try in the begin of your code

Please Login or Register  to view this content.

and at the end of your code

Please Login or Register  to view this content.

**lucasar** · 02-06-2014, 08:07 AM

Thank you Fotis1991.
That still requires the user to type the password, right? Is there a way to do this via code?
My goal is to prevent the user (in this case the secretary) of changing things by mistake.
If not possible I guess your solution will work too.
Thank you again!