I have some macros stored in worksheet module in an Excel file. I protect the whole VBA Project with a password so the code cannot be seen. But if that worksheet is moved or copied to another workbook, the code becomes visible without any passwords required. Is there a solution for this?
I am deliberately putting my macros into a worksheet module because I want users to copy this worksheet into their files and work with the macros. But I want to keep them locked for viewing.