Protect and Unprotect using vba

Good Morning,

I would like to run the below code on a protected workbook on a shared drive.
I am not quite sure how to do this. What I basically need to do is on the user pressing the button that runs the code, it would unprotect>write data>save>protect again.

Thanks for any suggestions!!!

HTML Code: 

Hi,

Is the workbook/worksheet password protected, and if so do you know what it is?

Rgds

hi...the workbook is not password protected....just protected cells.

the workbook is not password protected. The cells are protected and the password is GrayMck1425...Also, I have a Macro Button that will not run if the sheet is protected...Any ideas for that?

Hi,

Just use the following instruction in the workbook open event. Adjust the sheet reference as necessary. e.g. instead of ActiveSheet (which will run the macro on whichever sheet happens to be active when the WB loads), use Sheet1, Sheet2 etc...

Please Login or Register  to view this content.

HTH

Just to clarify....

I have a button on my main workbook that gets pressed and sends data to an outside workbook automatically.
I would like to protect the outside workbook. This is a workbook that only I will open.

example.... wb 1(this is the one the employees will interact with and has the export button)

employee opens this wb, hits the "submit results" button, and specific data is sent to an outside workbook to be evaluated.

This whole process is automated. The issue is that the wb where the results are going need to be protected. I need to add something to the above code, that when it automatically open, it unprotects, writes the data, resets protection, and saves, and closes.

The only part I don't have is it being protected.
If I try to protect it and run the code, I get an error that I need to "unprotect" the receiving wb.

Hope this makes sense????

Thanks

Hi,

Just include the .Unprotect instruction in the workbook open event as the first line, and as the last line use

Please Login or Register  to view this content.

HTH

so i would just add that to the code in my original post in the main wb?

Hi,

Yes that's right. Just make the two lines of code I gave you the first and last lines in the procedure you mentioned in your OP.

Rgds