HomeTechniques and Tips@RISK DistributionsPassword Protecting a Worksheet or Workbook

3.46. 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

This page was: Helpful | Not Helpful