If you are in desing mode and double click the button a new macro will
not be created. If you get a new macro then the name of the button
doesn't match the macro you are using. the macro also need to be in the
VBA sheet the crresponds to the sheet where the button is located. the
button will not work if it is in a different sheet, in a module, or in
THISWORKBOOK.


You also need to exit design mode for the button to work. It is
possible you may of create two macros with the same name. I would run
COMPILE from the VBA menu Debug - Compile to make sure there is no
errors in your macros.


--
joel
------------------------------------------------------------------------
joel's Profile: http://www.thecodecage.com/forumz/member.php?userid=229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=152998

Microsoft Office Help