Locking the use of Macros from other Workbooks

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

Hi Mordred - Its the same in 2003




Thanks,

Bonny Tycoon



**If I was able to help please click the small star icon at the bottom left of my post **

sorry, I'm on excel 2010 have just updated that aspect.

I've locked the VBA project for viewing using a secure password, my problem largely resides in the fact that you can open a blank excel workbook, then open my document and run a simple

sub Unhide_Sheets()
Sheets(1).visible = xlsheetvisible
Sheets(2).visible = xlsheetvisible
Sheets(3).visible = xlsheetvisible
end sub

And by running that macro when my document is selected it'll unhide the sheets.

Thanks
Maudise

I agree with Modred.. Now a days we have free add-ins and macros to hack or crack sheet passwords, workbook passwords and VBA passwords..

Its pretty much too hard to stop this from happening..




Thanks,

Bonny Tycoon



**If I was able to help please click the small star icon at the bottom left of my post **

ah well, we'll look at making it a secure website or something similar.

Many thanks for the help, I'll mark as solved considering it's not actually possible.

Maudise