VBA isn't hidden in protected workbook

[pruleone]

Hi,

I have made excel workbook, where are lots of sheets and some macros also.
I protected both sheets and workbook with password (I used different password just to make thing littlebit safer), so to make little harder to get hidden part of workbook.

But, , I use very much grouping and ungrouping. To get grouping work under password enabled sheet I had to make macro, where I inserted sheet password.

Now when I open that workbook and press Alt+F11, I can see all VBA codes, also this one, which includes sheet password.

Is there any way to protect workbook so, that all VBA-s are also protected?

 

[xlbo]

Protect the VBA project

Whilst in the VBE, Tools>VBA Project Properties>Protection

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question