Restrict VBA execution to a range o cells!

Good afternoon, folks!

I have a very simple code for copying formulae and formatting of the entire row where the cell is selected, adding a row below it and pasting it.
I call it through a button placed on the worksheet.
The thing is, I want it to work only when a cell within a certain range is selected (C28:I32).
If the selected cell is outside this range and I call the macro, I needed a Msg Box with something like "Not allowed".
Could you please give me hand?

Regards,

Ricardo

Please Login or Register  to view this content.

Hi, Kenneth!

Wow, fairly quick answer!
I tried that but what is it doing is the other way round of what I need.
Your is restricting the range C28:I32 and leaving the rest ok. I needed to allow the macro in the C28:I32 and stop all the rest.

Regards,

Special K,

Thank for your quick answer. I modified your code and it works wonderfully.

HTML Code: 

Thanks a million!