title: VBA code to reset command button sizes and place them at specific named ranges
body: <p>I'm using Excel 2010 - I have a number of named Command Buttons and Toggle Buttons that tend to move around or get set to a height and width of 0 so I want to add vba code to reset the command buttons and toggle buttons sizes and locate them at a specific named range.</p>
  
  <p>For example names cb1, cb2, cb3, cb4 to be set at range names cbrn1, cbrn2, cbrn3, cbrn4 respectively with a width of 20 and height of 20 and tb1, tb2, tb2, tb4 to be set at range names tbrn1, tbrn2, tbrn3, tbrn4  with a width of 10 and height of 10. How would I do this by using an if then loop? </p>
  
  <p>Your help would be more than appreciated :-)</p>