It's pretty ingenious, but imo even easier to view than the usual password protection.
Excel thinks the project is shared - even though the workbook isn't so won't show you the code.
I've seen Roy's approach before - or at least I think I have, it uses the in built mechanisms of Excel with regards to viewing projects in a shared workbook.