Invalid use of Me keyword

[icordeiro]

I am trying to assign this macro to a shape

Please Login or Register  to view this content.

The code works if I assign it to an activex commandbutton but when I insert it as a module and assign to the shape it gives the message: 'Invalid use of me keyword'

Any ideia on what I'm doing wrong?
Thanks

[xlnitwit]

Hi,

Me will only work in a class module. You should replace it with ActiveSheet if you want the code in a normal module.

[icordeiro]

xlnitwit thanks! it worked perfectly!