View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Alan Smykowski Alan Smykowski is offline
external usenet poster
 
Posts: 2
Default Add a Button with code

Is there any way I can add a command button using code
when a new worksheet is added to a workbook, the button is
called formatsheet and it calls formatsheet(), its
position will be left 1.5, top 14.25 Height 24.5 its
caption is ReFormat Sheet and it is not to be printed

Thanks in Advance