VBA - Turn sheet lock on/off

[CenaDK]

In my workbook I've got a sheet which only shows information from 1 other sheet. I don't want the user to open an edit this sheet without a password.
Is it possible to write som VBA code which turns this lock off, get the data and then put the lock on again in my macro?

Because if i lock the sheet know or hide it, my macro does not work since it can't get the information.

Does any of your got a smart suggestion on how to fix this little problem?


Thanks in advance.

[jraj1106]

Hi

Try this:

Book1.xlsm

[john55]

hi,
you can try this...

Please Login or Register  to view this content.

[CenaDK]

hi,
you can try this...

Please Login or Register  to view this content.

Hey John. The above code locks every sheet when i start my workbook from what I understand of the code?

[john55]

hi,
yes it locks all sheets but yr code works.
or you can add to every piece of code

Please Login or Register  to view this content.

or the solution provided by jraj

Please Login or Register  to view this content.