Add VBA code to an Excel by using VBA code

[Ironman]

Hi all - - I have the code below which assigns a password to a group of Excel file in a specific folder. It will open the first Excel workbook then saveas with a unquie password (Thanks to TMshuckk for his help on putting this together - - awesome!). This password code repeats it's self going through each excel workbook. Here is my next thought...I want to add to the password code, another set of VBA code that will 'lock' a group of columns, while leaving other columns available for editing and updates.

Is it possible to incorporate the Locking VBA code while the Workbook is open via the Password VBA code?

This is the locking VBA Code, I wish to incorporate into the Password VBA Code:

Please Login or Register  to view this content.

Here is the Password Code:

Please Login or Register  to view this content.

Is this even possible? Thanks again! Hope everyone has a good weekend!

[HaHoBe]

Hi, Ironman,

you have to change the fileformat of the workbooks saved from xlOpenXMLWorkbook (without macro's in 2007-2010, xlsx) to xlOpenXMLWorkbookMacroEnabled (with or without macro's in 2007-2010, xlsm). And for passing code you may have a look at Chip Pearsonīs Programming The VBA Editor especially Copy A Module From One Project To Another and Creating An Event Procedure.

HTH
Holger