VBA sheet protection

[Lord_B]

Hi All, thanks in advance for looking,

This might have been answered before but if it has I haven't found it.

I think i might be asking the impossible but here goes.

I would like to try and protect my workbook as much as possible from the zip extension hack.

I have a workbook with around a dozen worksheets with locked/unlocked cells and the sheets are password protected.

Now, if the password is striped out by the above mentioned is there a way to have the password re-activate once the workbook is opened?

Or is there a way to hard code a password to all sheets that cant be removed?

Again, I think this might be impossible or I might have to buy some software but any pointers/solutions will be greatly received.

Thanks for looking,

Ben

 

[Kamolga]

Hi,

You can protect the worbook and the sheets on

Private Sub Workbook_Open()


End Sub

(2x click ThisWorkbook in VBA).

Issue is that those passwords are really easy to remove (I spent like 10 min on google).

My issue is I can really overprotect a workbook (no menu, no arrows, no sheet or even Hide Excel) with VBA

[TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64"]Sub MaxScreen()[/TD]
[/TR]
[TR]
[TD]'Hide sheet tabs[/TD]
[/TR]
[TR]
[TD]ActiveWindow.DisplayWorkbookTabs = False[/TD]
[/TR]
[TR]
[TD]'Hide status bar[/TD]
[/TR]
[TR]
[TD]Application.DisplayStatusBar = False[/TD]
[/TR]
[TR]
[TD]'Hide scroll bars[/TD]
[/TR]
[TR]
[TD]With ActiveWindow[/TD]
[/TR]
[TR]
[TD]   .DisplayHorizontalScrollBar = False[/TD]
[/TR]
[TR]
[TD]   .DisplayVerticalScrollBar = False[/TD]
[/TR]
[TR]
[TD]End With[/TD]
[/TR]
[TR]
[TD]'Hide formula[/TD]
[/TR]
[TR]
[TD]Application.DisplayFormulaBar = False[/TD]
[/TR]
[TR]
[TD]'Minimizee ribbon[/TD]
[/TR]
[TR]
[TD]If  CommandBars("Ribbon").Controls(1).Height < 100 = 0 Then  CommandBars.ExecuteMso "MinimizeRibbon"[/TD]
[/TR]
[TR]
[TD]Possible to block scroll area  in properties of the sheet is a good way to protect as well[/TD]
[/TR]
[TR]
[TD="class: xl63"][/TD]
[/TR]
[TR]
[TD]End Sub[/TD]
[/TR]
</tbody>[/TABLE]

but te security allow users to open files without launching the macro's.

 

[Lord_B]

Thanks for the reply, that's basically what I thought