GRCArizona
Board Regular
- Joined
- Apr 24, 2010
- Messages
- 95
Hi -
I've got an Excel file that is password protected and VBA project protected. I just noticed that when I (and eventually any End User) right clicks selects "Move or Copy" ==> "Create Copy" ==> "New Book", the worksheet level code is visible in the newly created workbook.
Has anyone noticed this before? Can't believe it would be so easy to view code. Does anyone have a piece of code that would alleviate this?
Thx,
GRC
I've got an Excel file that is password protected and VBA project protected. I just noticed that when I (and eventually any End User) right clicks selects "Move or Copy" ==> "Create Copy" ==> "New Book", the worksheet level code is visible in the newly created workbook.
Has anyone noticed this before? Can't believe it would be so easy to view code. Does anyone have a piece of code that would alleviate this?
Thx,
GRC