Locking VBA module so view only
 

I have an Excel VBA module that I wish to stop users changing the
VBA code, but allow them to look at the code.

I seem only able to prevent viewing as well as changes.

Can I lock it and allow them to view only?

Ian,

Locking VBA module so view only
 

I don't think so.

Maybe you could send them a text file with the code or another (unprotected)
version of the workbook.

Ian wrote:

I have an Excel VBA module that I wish to stop users changing the
VBA code, but allow them to look at the code.

I seem only able to prevent viewing as well as changes.

Can I lock it and allow them to view only?

Ian,

--

Dave Peterson