VBA code for work book open event

[Caze982]

Hi everyone

I have workbook that i want to protect with a password and when it opens ask for the password. i want to use vba code. Does anyone know how to do that?

Sincerly
Christian

 

[gallen]

You can password protect by protecting your workbook. (Review Tab > Protect Workbook)

Using VBA is possible but if people don't have macros enabled then the code won't run. Only way around that, if VBA MUST be used is to hide all the sheets until they click a button which ensures they can only view the workbook if macros are enabled.

 

[Caze982]

You can password protect by protecting your workbook. (Review Tab > Protect Workbook)

Using VBA is possible but if people don't have macros enabled then the code won't run. Only way around that, if VBA MUST be used is to hide all the sheets until they click a button which ensures they can only view the workbook if macros are enabled.

Thank you for your answer. I would like to use vba code, do you know how to do that?

Sincerly
Christian

 

[RoryA]

May we ask why? It's far less secure than setting a password to open the workbook by encrypting it.

 

[Caze982]

May we ask why? It's far less secure than setting a password to open the workbook by encrypting it.

Yes, i am trying to create 100 examples of how to use vba code, for my colleagues.