Hi
Did you put the macro in the right place?
In the vb editor, double click the appropriate sheet name listed with
your project. Paste the macro into the window that appears (the module
for that sheet).

regards
Paul