How to disable editing in Analysis for office

[NAGENDRA P]

I need to disable edit mode in Sheet by using vba macro.
Can anyone assist?
- Button needs to be created on clicking will disable editing in active sheet of workbook

[prasadk]

You need disable edit mode in sheet
Try this code if it is helpful to you or not





Private Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, _
ByVal Target As Range, Cancel As Boolean)
Cancel = True
End Sub

[Paul_Hossler]

Lock all the cells and protect the sheet