Hiding Images via Macro

Hi there, this is my first post here, just looking for some help with an assignment i've been given as my lecturer is useless.

Sorry i meant to post this in Excel section.

I have created a quiz with images that gives you point upon clicking the correct one, but the problem is you can click any image multiple times until you get the right one.

I was looking for something that would work like this:

Click Pic1 >
Pic2, Pic3 and Pic4 all go invisible

I know the macro command (.Visible = False) but im not sure how i would code this so it would work?

Here's what my VB statement looks like at the moment

Sub Picture6_Click()
MsgBox "WRONG!", vbOKOnly, "Incorrect"
Range("G73").Value = "0"
End Sub
_________________________________________________________
Sub Picture7_Click()
MsgBox "WRONG!", vbOKOnly, "Incorrect"
Range("G73").Value = "0"


End Sub
_________________________________________________________
Sub Picture8_Click()
MsgBox "WRONG!", vbOKOnly, "Incorrect"
Range("G73").Value = "0"


End Sub
_________________________________________________________
Sub Picture9_Click()
MsgBox "Correctamundo!", vbOKOnly, "Correct"
Range("G73").Value = "2"


End Sub

And heres something i came up with (which encountered errors naturally).

Sub Hide()
If Picture6_Click = True Then
Picture6.Visible = False
ElseIf Picture7_Click() = True Then
Picture7.Visible = False
ElseIf Picture8_Click() = True Then
Picture8.Visible = False

How about

Picture6.Enabled = False

Please Login or Register  to view this content.

I tried this but i get an error
"Run-time error '424':
object required.

Thanks for the help.

NOTE: Sorry i've realised now that this is in the wrong section, it was intended for Excel but i wasnt paying enough attention
My apologies :p

Sorry didn't notice its a module

try to move your codes to General
then use
private sub - end sub

Please Login or Register  to view this content.

Sampler to hide and unhide