Spreadsheet snapshot in UserForm
 

I want to hide my xls sheet behind a fullscreen UserForm, but ...
display a number of rows of the xls sheet in the Userform (for
information, non-editable).
Ideally the layout of the sheet (column widths, colors) should remain
the same on the form. So a real snapshot would be great!
Anyone tried this already?


---
Message posted from http://www.ExcelForum.com/

Spreadsheet snapshot in UserForm
 

See Stephen Bullen's PastePicture.zip
http://www.bmsltd.co.uk/Excel/Default.htm

Regards,
Greg

-----Original Message-----
I want to hide my xls sheet behind a fullscreen UserForm,
but ...
display a number of rows of the xls sheet in the Userform
(for
information, non-editable).
Ideally the layout of the sheet (column widths, colors)
should remain
the same on the form. So a real snapshot would be great!
Anyone tried this already?


---
Message posted from http://www.ExcelForum.com/

.