Solved: Disable all saving

[Blackie50]

Picked up following code but as it disables all saving it won't save the code.

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
' Following line will prevent all saving
Cancel = True
End Sub


How do I get it to save the code in the workbook module?

thanks
Jon

[mancubus]

hi.

open workbook macros disabled, then save.

[Blackie50]

Cheers - really simple

regards
Jon