hi all i have a excel sheet in which an arrow shape is their , in that shape a macro is assigned ,i want as we click on the arrow macro will run and that arrow shape gets hide automatically as soon as the macro complletes