View Single Post
  #7   Report Post  
phil6666
 
Posts: n/a
Default


I followed Excel "help" and copy/pasted exactly what you wrote & it
works perfectly!!!

Now, if I only had a minimal clue what macros really can do.......


On Sat, 19 Mar 2005 04:58:47 GMT, Andy wrote:

ToolsCustomizeCommandsMacros

Drag the Custom Button (yellow smiley face) to your toolbar, right
click on it, assign macro (you have to have a worksheet open so the
assign macro dialog box comes up). Right clicking on the button while
the ToolsCustomize dialog box is open will also give you some other
options (like changing the smiley face).