Run macro from activeX button to module? strange error?

[behedwin]

Hey

I cant figure this out. I dont know why i get this error when trying to run a macro of a activeX button in excel 2016.

I have this code:

Please Login or Register  to view this content.

Then i have this code

Please Login or Register  to view this content.

I have tried to remove "call" but it still does not work.

Anyone able to help me run a macro from a module?

This is the error i get.
http://prntscr.com/nev9u3 (screenshot)
variable not defined

But why should i define a variable, all i want is to hide or unhide a control.

How should i type this code.
Not been able to find any solution yet.

[PCI]

And what's up if you put the code (imghidd) in the sheet's code not in a module

[behedwin]

The code works if i put it in the sheet´s code and not the module.
But i want the code to run from the module and not the sheet´s

How can i make this happen?

[PCI]

Reviewing the error message it is pointing out a variable not define ...!
Which statement is higtlighted ?
Where is the label extinstr1_label ?

Can you attached an Excel sample file ?

[shg]

The code works if i put it in the sheet´s code and not the module.
But i want the code to run from the module and not the sheet´s

Prefix with the codename of the sheet, e.g.,

Please Login or Register  to view this content.

[PCI]

See next code where the sheet's name is mentioned

Please Login or Register  to view this content.

[behedwin]

I have setup an example excel and for some reason that code work.

it reacts on sheet1 with the same error
Sheet1.extinstr1_label.Visible = True

but i have tried sheet1-sheet10.
can i define my sheet some other way?

the file i need to build this is in, is quite old. maybe someone have created 100 sheets and i should have sheet35 instead... i dont know

[behedwin]

See next code where the sheet's name is mentioned

Please Login or Register  to view this content.

Perfect, this worked!!