How to disable menu items like Save, Save As in OpenOffice Calc using Macro?

Question

0.00/5 (No votes)

See more:

Hi,
I want to disable Save and Save As options in the File Menu of OpenOffice Calc using Macro. I have tried the following code,

VB

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
    MsgBox "You can't save this workbook!"
    Cancel = True
End Sub

But it doesn't works, Please help to achieve this. Thank you.

Posted 5-Nov-15 23:14pm

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Answer 1 · 2015-11-06T07:55:00

Posted 6-Nov-15 7:55am

Comments

VR Karthikeyan 7-Nov-15 0:32am

Thank you, useful links.

Maciej Los 7-Nov-15 5:32am

I'm glad. Can you accept my answer as a solution (green button) - formally to remove the question from unanswered list?