microsoft-excel-courses - option button control toolbox

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft-excel-courses - Option Button on Control Toolbox

microsoft-excel-courses - Option Button on Control Toolbox

resolvedResolved · Low Priority · Version Standard

Option Button on Control Toolbox

How can I use option buttons in Excel?

RE: Option Button on Control Toolbox

Hi James

You can add an option control by viewing the FORMS toolbar
VIEW > TOOLBARS > FORMS

Then single click the option control button, and then click on the worksheet where you want it to appear.

Right click the option button to edit the text, or format the control.

Regards

Richard


 

Excel tip:

Make macros work in newer versions of Excel

If you have created macros in Excel 97 or 2000 that you want to be able to use in 2002/XP or 2003, you may need to alter the macro security settings in the newer version of Excel you are using.

To do this, go to Tools - Options - Security.

Select Macro Security and change the security setting to Low.

Tick the boxes next to 'Trust Add-ins' and 'Trust Visual Basic' and click OK.

After you have restarted Windows, you should then be able to use your macros created in earlier versions of Excel.

View all Excel hints and tips


Server loaded in 0.09 secs.