I created a security system on an excel worksheet.
I protected the worksheet VBA modules with a password.
I then changed the security system.
I now have to go and update every single worksheet to work with the new system.
The security system was a macro in Excel.
Is it possible to , with VB, edit Excel Modules through a program?
eg: change the actual source code in the Excel macro through and external Visual Basic Program?