A ahhhmed Member Jun 19, 2011 #1 Hi, Where can I get the camera tool in a spreadsheet to view the contents of another one?
dan_l Active Member Jun 19, 2011 #2 Excel 07: Orb > excel options> customize > add it to your quick access tool bar.
A ahhhmed Member Jun 19, 2011 #3 thanks. How do i attach a scroll bar to the picture? I know where i get the scroll bar, but how can i adjust its properties to connect it to the picture?
thanks. How do i attach a scroll bar to the picture? I know where i get the scroll bar, but how can i adjust its properties to connect it to the picture?
dan_l Active Member Jun 19, 2011 #4 I'm not sure if you can make the camera tool dynamic like that. The source data comes from another workbook?
I'm not sure if you can make the camera tool dynamic like that. The source data comes from another workbook?
Luke M Excel Ninja Staff member Jun 20, 2011 #5 If you want to use a scroll bar, I think you need a "in-between" step. 1. Scroll bar linked to cell changes some number 2. Linked number is fed into a dynamic named range 3. Picture link uses "simple" formula to reference named range, e.g. "=PictureRange"
If you want to use a scroll bar, I think you need a "in-between" step. 1. Scroll bar linked to cell changes some number 2. Linked number is fed into a dynamic named range 3. Picture link uses "simple" formula to reference named range, e.g. "=PictureRange"
