Protecting the worksheet: Run-time error

[ali_lum]

Hi,

I have protected my worksheets on my excel. I have two worksheets, one called 'launch' and one called 'data', both locked using the same password. This obviously caused an error when the userform attempted to send data into the worksheets.

I have tried the two following pieces of code:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

I have also changed the 'write password' property of the worksheet to match the password for the worksheets, but still nothing. I am getting a run-time error 1004.

Thanks to anyone that can help, maybe missing something simple..

[Blokeman]

Show the code from the userform.

[ali_lum]

Hi Blokeman, thanks for replying

My code is too long to include. Can you be specific as to which section(s) of code you want to see? Thanks for your help, Ali.

[:) Sixthsense :)]

I suspect any of the sheet is protected with someother password.

Un-protect the sheets manuall and try protecting it via code and check