Password and Macro

[Foxcan]

I have an excel spreadsheet that has password to open it as well a read only prompt. What I would like to happen is after the user has typed in the password, clicked ok, and then clicked either "yes" or "no" for read only or not that a specific named macro immediately is run.

How do I do that?

[shg]

You can invoke the procedure from the Workbook_Open event, provided the user has enabled macros.

[Foxcan]

I am a novice using macros. Can you help me with the actual code? Thanks

[shg]

In the VBE, select the ThisWorkbook module. In the code window, select Workbook from the left dropdown, and this code will appear:

Please Login or Register  to view this content.

Call your macro from there.

[Foxcan]

Thank you very much!