How to add macros to drop down box?

[jgomez]

I’m trying to add a macro to the drop down box so if 1 is chosen it should unhide rows 12:13, if 2 is selected then rows 12:16 should be visible but every time I try to record the macro I get a “Run-time error ‘70’: Permission denied” error. Not sure what I’m doing wrong…

1 selection should unhide rows 12:13
2 selection should unhide rows 12:16
3 selection should unhide rows 12:19
4 selection should unhide rows 12:22
5 selection should unhide rows 12:25
6 selection should unhide rows 12:28
7 selection should unhide rows 12:31
8 selection should unhide rows 12:34
9 selection should unhide rows 12:27

Can someone please tell me why I’m getting this error & help me out here??? :D.

[watersev]

hi jgomez, please check attachment

[jgomez]

Thanks a bunch!

[jgomez]

How did you do it? I need to know... can't rely on you guys all the time...