Is there a way to copy from a hidden sheet to a hidden dialog box?

This is what I am trying to do. When something is selected in a drop down
box, I want a picture on a hidden sheet copied and pasted to a dialog box,
then I want this dialog box (hidden from editing) to pop up(which i can do).
The dialog box I have no problem with, in fact i can even copy and paste
everything if the sheets aren't hidden. However, when you hide the sheets you
can't select them so how can you copy & paste from them?
Any help would be greatly appreciated, I have got some wonderful answeres in
this group before.

address the sheet in VBA

Worksheets(sheetname).Range(abd).Copy
worksheets(targetsheet).range(def).Pastespecial xlAllValues

works whatever the visible property is of either sheet
remember that you don't need a sheet to be active to cut/paste

--
Patrick Molloy
Microsoft Excel MVP
---------------------------------
I Feel Great!
---------------------------------
"Web_Builder" wrote in message
...
Is there a way to copy from a hidden sheet to a hidden dialog box?

This is what I am trying to do. When something is selected in a drop down
box, I want a picture on a hidden sheet copied and pasted to a dialog box,
then I want this dialog box (hidden from editing) to pop up(which i can
do).
The dialog box I have no problem with, in fact i can even copy and paste
everything if the sheets aren't hidden. However, when you hide the sheets
you
can't select them so how can you copy & paste from them?
Any help would be greatly appreciated, I have got some wonderful answeres
in
this group before.