How do I save Excel worksheet w/radio buttons as interactive web page?

UNCjigga

Lifer
Dec 12, 2000
25,627
10,330
136
Okay, here's what I'm trying to do.

I have created a nifty little tool for a new marketing campaign at my company. Right now, the tool exists as a MS Excel worksheet. The main sheet contains questions that a potential client would be able to answer by clicking on radio buttons. As the client clicks away, the sheet is actually calculating the client's need for our product based on their input. This is all done in hidden cells etc. so the client doesn't see the calculation/formulas of course--they just see a clean, simple survey. When the client is done, they can click the tab for the 2nd sheet, which shows them their need for our product graphically (based on the calculations, their need will be graphed as high or low in two dimensions.)

Now how do I retain all this functionality in converting this to a web-based tool? The 'Publish as Web' option in Excel doesn't do it (I am using the latest Excel XP with SP1.) Even when I click 'add interactivity' it doesn't work (it just lets me scroll the sheet, but the radio buttons don't even show up!)

Any suggestions?
 

UNCjigga

Lifer
Dec 12, 2000
25,627
10,330
136
Okay well, I've found the problem. Basically, I did all the radio buttons/interactivity through Excel's forms toolbar. In order to have it work on the web, however, I need to redo EVERYTHING in Microsoft Script Editor (which is ActiveX based I guess.) Does anyone know an easy way to do this?