Using Excel VBA to capture edit mode through checking the standard tool bar
Posted
by srimal
on Stack Overflow
See other posts from Stack Overflow
or by srimal
Published on 2010-03-19T11:04:46Z
Indexed on
2010/03/23
12:03 UTC
Read the original article
Hit count: 486
I'm using this code to check if the standard toolbar is deactivated in the edit mode.
CommandBarControl oNewMenu = Application.CommandBars("Worksheet Menu Bar").FindControl(1, 18, 1, True, True)
If (IsNull(oNewMenu)) Then
MsgBox "Edit mode enabled"
End If
but the FindControl function raise an error. Is there any conflict in the parameters?
© Stack Overflow or respective owner