Home → Techniques and Tips → @RISK Distributions → Password Protecting a Worksheet or Workbook
Applies to:
@RISK 6.x/7.x
I want to password one sheet in a workbook. How can I do that, and still run a simulation?
@RISK can store and remember the password after you provide it once. See "Protected Workbook: This operation cannot be performed ...".
I want to protect the whole workbook, and the above technique doesn't work. Is there another option?
If you protect the workbook by File » Save As » Tools next to the Save button) » General Options, you can write a VBA function to provide @RISK with the password. See "GetPassword cannot be found." This technique will not work if you protect the workbook with the Protect Workbook command on Excel's Review tab.
Last edited: 2018-03-09