Run time error 1004: Unable to set hidden property of range class

[SAVIOBLUEFOX]

Hi there,

I am completely new to VBA coding on Excel (just living off tit-bits from the net) and would need some help.

Have a sheet wherein BW2 is an Option Button when clicked hides or opens AK: BV. All works fine as long as sheet is unprotected.

However once sheet is protected, the Option buttons dont function thereby throwng up the error as listed on the subject line.

Would need some guidance on this please.

Please Login or Register  to view this content.

Thanks,
Saviobluefox

[JasperD]

Hi SAVIOBLUEFOX,

welcome to the forum.
Please put code tags around your code for easier reading.

The way to go would be to unprotect the sheet, run the code and then protect it again.
In your example, it'd look like this :

Please Login or Register  to view this content.

Please click the * below if this helps

[SAVIOBLUEFOX]

Hi JasperD,

Thanks heaps for coming back to me so quickly. And yes, the code you suggested works

Also thanks for guiding on the code wrap ups. I have now done it above just to try (better late than never)

Thanks again,
SBF

[JasperD]

Glad to be of help. Please mark the thread as solved.
You can do this by clicking "thread tools" above your first post and then selecting "mark thread as solved", thanks.

Happy coding ;-)

Please click the * below if this helps