Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Programmaticlly sign and password protect a VBA Project in Excel 2
Hi
I have a workbook that has a vba project attached which is signed and password protected. In this workbook I've created a sub that creates a new workbook (by moving a worksheet to a new workbook) adds code to its "ThisWorkBook" module (basically to unprotect, process data and protect the worksheet when a user makes changes to a specific range).Thus this code contains passwords to protect and unprotect a worksheet which I don't want any of my users to view if they open the VBA editor. I need to be able to programmatically password protect the newly created workbook's vba project and add the original workbook's signature to it to enable macro functionality on it. Could someone please advise on how I go about this as I am baffled. -- Rocco Coetzee |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007's VBA Project password security | Excel Programming | |||
Cant Digitally Sign Excel VBA Project | Excel Programming | |||
VBA project password for builtin Excel templates | Excel Programming | |||
password protect project with VBA code | Excel Programming | |||
Accesing vba project from wb that has vba project password protected | Excel Programming |