Private, lock together.

[JohnSeito]

Hello all,

Ok, here is the problem. I wrote a code in visual basic, but I want it to be private, so that the name of the macro can't be see when they click the play button. I could do this no problem, just "private macro"

but... when I put private, it seems that this code

Worksheets("name").Unprotect Password:="password"

doesn't work, this code locks the sheets so it can't be alter.

any idea? i want to put the code private, and lock the sheet.

thanks,

[royUK]

Where have you put the code. This works when placed in a Standard Module

Please Login or Register  to view this content.

[JohnSeito]

I put the code in the private model, where the macro I wrote is in. the reason for this is b/c so that when someone click on the macro it runs it, it unlock, unprotect the worksheet, to run the code, then locks it again.


to do this, this code

Worksheets("name").Unprotect Password:="password"

only works on standard, sub, not private.

i want it to be private code, with the ability to protect and lock the worksheets.

thanks