I have been looking, but can't seem to find an answer to this problem. Is it possible to publish a workbook in HTML that has the same functionality as the Excel program has? Is it possible to do this using VBScript? Can any one offer a suggstion that might make this possible?

What I am trying to do is this -- I have a huge workbook (10 mb) that I want to make available to others in my firm. The sheet updates prices and various statistics daily. The main interface allows brokers to enter tickers and share amounts feeding off the updated sheet to create a portfolio report. When I try to save as HTML, it seems that only one page is taken and then all of my buttons and "extra" items are not shown.

Any thoughts?