This sounds like an in-house distribution, how persistant are the "bad guys"?

Put the password in a cell on a locked and hidden sheet might work. Using the Rand to change the each time the workbook is opened might be an idea.