I believe the following will work from your example:
Sub_Activate_Deactivate()
If range("A12")="x" then Call Start_Up
If range("A12")<"x" then Call Hide
End Sub
"JAD" wrote:
The following is a simplified logic statement that I am trying to write in
VB. If someone could interpret it and make it work in VB, I would appreciate
it. What I am trying to do is active/run a macro whenever a specified cell
shows a value of "x". Here is the incomplete statement:
Sub...........Activate_Deactivate
If cell A12="x" then
Activate Macro named Start_Up
If cell A12<"x" then
Activate Macro named Hide
End Sub