Preview of Spreadsheet/Document
 

I am using Excel 97.

I am wanting to add a preview of a document in a userform. Can anyone
supply me with some code which creates the preview of a document.

Many thanks

--
Mark

Preview of Spreadsheet/Document
 

See Stephen Bullens site for a technique of displaying a picture of a chart
on a userform.


http://www.oaltd.co.uk/Excel/Default.htm



you would have to do a copypicture on your range and follow a similar path.


--
Regards,
Tom Ogilvy

"Mark" wrote in message
...
I am using Excel 97.

I am wanting to add a preview of a document in a userform. Can anyone
supply me with some code which creates the preview of a document.

Many thanks

--
Mark