Password Protection in Macro

[asifmian55]

I am trying to develop a spreadsheet with some data in it. Once a user enters the data, clicks on Submit Data. The Submit Data activates a macro which password protects the worksheet. I already have a macro doing this but without password. Is there any way I can add password protection in macro?

[xlnitwit]

Hi,

Yes, you simply add

Please Login or Register  to view this content.

as an argument to the line that protects the sheet- for example

Please Login or Register  to view this content.

[buran]

you can use Protect method of worksheet object, e.g.

Please Login or Register  to view this content.

of course you can specify certain allowed and forbidden actions, e.g.

Please Login or Register  to view this content.