VBA - Locking sheet for editing with macro

Hi team,

I have a little userform that is used to gather information about some orders...What it does is lets the user enter all information and all this info gets copied to a sheet... I would like to be able to actually not let anyone be able to edit the data once it's been copied... In the past I had tried locking the cells and protecting the sheet but this caused me many errors with the macro as it wasn'T able to write... Any ideas on how I can encounter this or what my options are here..

Thanks team!

Hi DJ,

mu suggestion would be.

Before you run the macro, add below code

Formula:

Please Login or Register  to view this content.

and once the macro finished, add below code:

Formula:

Please Login or Register  to view this content.

Cheers
Lex

I've been looking for this too. This works great. Thanks, all.

Hi Lexusap,

Thank you ! It works BUT once I make the file a shared file (Which is what I need as many users use this file at the same time).. I get an error : Unprotect method of worksheet class failed... Runtime error 1004

Hey I actually found a solution to my question..Tell me if I'm doing this right...Will the fact that i'm temporarily disabling sharing the file for a few seconds cause any issues?

I first de-activated the sharing feature

Please Login or Register  to view this content.

Then I un-protect my sheet

Please Login or Register  to view this content.

Then Add this in the end:

Please Login or Register  to view this content.

I also added this to remove all the annoying display alerts I was getting for unsharing and sharing file:

Please Login or Register  to view this content.

at the bigging

and

Please Login or Register  to view this content.

at the end

Hey Team...Following my previous post I tried it on 2 differenct pcs and when I cam back to my first pc to try to enter another entry..I got an error the file is no longer shared...Any help on this one ?