Quote Originally Posted by parry
open up the Control toolbox and then right click a blank area of the toolbox and select Additional Controls. Scroll down until you see Microsoft Office Spreadsheet 10.0 and put an x in the box and this control will be added to the control toolbox........(etc)

.......As a suggestion you could simply have an entry sheet with drop-downs etc that the user inputs info into and then clicks a button which populates it to the correct sheet/range. Like a front-end if you like. Call me old fashioned but an embedded worksheet on a form doesnt sit right with me.
NOPE...Doesn't work for me on Office97, all I get is 'Tidestone Formula One 6.1 Workbook' which I must admit DOES do the job but leaves unanswered the unauthorised use Vs. licensing/payment problems (mentioned in my last post) for what I intended to be used as a freebie. But thanx for the input anyway.

I know what you mean by the last bit. I did try several other options first and got various ppl to 'test-run' them. For speed, ease and simplicity for the end-user, this type of solution really does appear to be the best option for the front-end.
(N.B. If they know what they're doing they can (as I do) simply use the spread-sheet to make their entries, but I know that most of the ppl using it - being part-time volunteers - will not know very much about what they're doing and need to be presented with the option of a much smaller range of columns and cells to search through/choose from to make their entries...Yet still presented in a s/s form to teach them so that they can eventually learn to bypass this function altogether and read and use the main s/s for entries)