The macro recorder works very well for this, start the macro recorder and goto options, and do what you want.
Place the code in your workbook open event and be sure to reverse it in your workbook close event.