Excel command button macro

Hi,
Want to create a macro that at the click of a button on sheet1 it will run the macro on "Pivot" sheet The macro is working fine when I manually run the macro through
tools->macro->run macro,but when I try to run that through command buttonits not working..

You have to specify the sheet.

Please Login or Register  to view this content.