Last protect proble.

[Tom]

Hello,

now how can I lock all macros and forms againts editing? Its possible do
that in Workbook_open(), or I have to do it in VisualBasic Editor?

Thanks
Tom

 

[Dave Hawley]

Hi Tom

While in the VBE go to Tools>VBAProject Properties-Protection.

You will need to Save, close and re-open for the Protection to take
effect.

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum ***

 

[JE McGimpsey]

The OP should be aware that this protection is very weak. Anyone with
enough knowledge to search the archives can find ways of bypassing it.

 

[Dave Hawley]

Agree! It would also be good if some members stopped posting code to
crack internal Workbook protection, Sheet protection etc. IMO This sort
of stuff should exist on on carck sites.

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum ***