Error message when trying to create & use macros

[worthmw]

Hello all,

I am using Office 2016 and I am not a programmer but I can usually figure things out. I've created a simple example spreadsheet which I have attached. It is a macro enabled worksheet. I want the macro to be able to show or hide rows 2 through 8 but I keep getting this error message. what am I doing wrong?

Thanks again

Oh, and also, is there no way to add a background color to a command button (form control)?

[jolivanes]

Macro needs to be in a regular module.
Stay away from selecting as much as possible
See changed code in attachment.

As far as color goes, not as far as I know but you can use any shape, picture or whatever your heart desires and use it as a "macro caller".

[jolivanes]

You can shorten the code to so:

Please Login or Register  to view this content.

[worthmw]

Thank you jolivanes, I'll try that once I get the macro working

[worthmw]

Thank you for this one as well jolivanes. I prefer to use shapes but I couldn't get the macro to work so I switched to command buttons