transferring data to a protected sheet

Hi

I have a workbook which when closed makes all sheets protected. I want to be able to transfer data from Weekly Graph sheet to the Score sheet while the Score sheet is in the protected mode. If I un-protect Score Sheet first and then transfer data it works fine but if I have the Score Sheet protected it gives an error.
need to be able to transfer data from Weekly Graph sheet to a protected sheet called Score

Also when the workbook is closed it changes the caption on the Weekly Graph sheet commandbutton to Unprotect Sheet.How do I change the code so that on the Score sheet it also says Unprotect Sheet when workbook closed.So when I open up the workbook both buttons always say Unprotect Work Sheet (weekly Graph and Score)

Thank you

Paul

I don't think you can change protected sheets to unprotected in code

same as japandave. It is well protected. what is the password??


also, sorry if the post before was a duplicate. we posted at about the same time

thanks

I not sure here but does an argument called UserInterfaceOnly help ​. If set to "true" then protection will not apply to macro's and thus allow your code to run unhindered.

The second question - uses this code when the workbook is closed...I want to add the Score sheet to this as well

This code below is in ThisWorkBook

Please Login or Register  to view this content.