View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Web_Builder[_2_] Web_Builder[_2_] is offline
external usenet poster
 
Posts: 10
Default copy & paste from & to hidden sheets

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.