How to insert NICE Form Control Buttons

Hi All

Does anyone know how to insert an attractive form control button instead of the horrible default grey buttons that come with Excel? I've seen it done, so I know it can be done....

Any pointers appreciated....

Thanks!
Sunil

Hi Sunil,

You can assign a macro to just about any shape you like. To do so follow these four steps:

1. Get your desired shape onto the tab in question (whether you create it, copy & paste it, or import it or whatever),
2. Right-click it and from the short-cut menu select Assign Macro
3. Click the relevant macro name from the Macro name listbox on the Assign Macro dialog
4. Click OK

HTH

Robert