Hi All,

I have an interesting conundrum. I have been given an excel spread sheet which contains sheets which should remain hidden and protected at all times. So far I have protected the sheets, made them VeryHidden and locked the VBA project for editing. My problem however is that if you open another instance of Excel and hit Alt+F11 you can run macros which will make the sheets unlocked and visible.

Is there a way to lock Excel further so that if a specific spread sheet is open then it doesn't allow for macros which are written by the user to bypass the security?

The information behind it is calculations and I have of course suggested that they rebuild it in a more secure manner, at least at first making VBA do the calculations but we don't have the time to deliver that just yet.

any and all help would be appreciated on this one.

Many Thanks
Maudise