camera tool

Hello all! I have been reading posts here and online and i'm not sure which path to try. I have a Userform with many buttons that lead to various "Orderforms" - 1 per vendor. What my macro does is capture the info from each vendor onto 1 "Summary" Sheet and 1 "customer info" sheet. (I guess...

Hello all, I have a specific request that I haven't been able to find on the message boards. My tabs are labeled Sheet1 and Sheet2 - Sheet1 - I would like to have a checkbox in Cell A1 that if checked, will use the Camera Tool to copy a data table from Sheet2 using the Camera Tool. The image...

I have a spreadsheet with multiple tabs: Sheet1 is Summary and Sheet2 - Sheet20 are all the details (but from here on, we will focus on Sheet1 and Sheet2 as Sheets3-20 will follow the same logic as Sheet2, but I don't want to be told that if it is only one sheet why waste my time). Sheet1!B1:L1...

I have a workbook that has 9 sheets of data. On 8 of the sheets I want to add a macro button to display or not display a predetermined "Camera" image from the 9th summary sheet. The image would be a summary of data specific to the sheet the user is on, and that the user can either display or...

Hi all, I am trying to figure out how to add a button that will save a image that was generated via the excel camera feature. Basically I am pulling via lots of slicers data together and want the user to be able to save the image in order to attach it to emails. Unfortunately there is only a...

Trying to figure out why when I use the camera tool to copy a range the past result is "cropped". The formula bar indicates the proper range however only about 50% of the range is displayed

Hi, I am working on a dashboard where I am creating drop down dependent charts. For this I have used camera tool to display the picture of graphs (created in separate sheets) selected in the drop down and I am using CHOOSE function to decide the order. The problem is all my graphs are not...

Hi All, I am new to here but impressed with the level of knowledge shown and would appreciate some help I possible. I am trying to attach an image to a comment so that it will show when you hover over the cell. I know this can be done with saved image files from defined paths, and here's the...

I'm using Excel 2010. When I use the camera too to take a snapshot of a range of cells in one worksheet and "paste" them into another worksheet they look fine, update properly, etc. However, when I print the worksheet the camera image prints with the column letters & row numbers around the...

Hello all, I'm working on a excel sheet to design control panels and as part of this program I have been told to insert pictures of the components (Preferably to match up with what gets sent to the customer) it was also required that I avoided the use of macros, VBA and any add-ons. I have...

I am trying to show 2 sparklines in the same cell. So I've created both sparklines off to the side and used the Camera Tool to get them both into one cell. I've made the image fill transparent so that I can see both images in the same cell in Excel. The problem is that when I try to print out...

In Excel 2010, I used the camera tool to take a snapshot of a selction of cells. How do I save the snapshot only as a JPG or GIF file? I know that there are programs outside of Excel that can take snapshots or print screens, but I need to accomplish it using the camera tool so the snapshot is...

Hi Everyone, I am using the camera tool to automatically update pivots for country specific data which are kept in their own sheets (USA, Canada, Mexico, Brazil are all in separate sheets). When the monthly data feed is updated, the pivot tables expand and grow in size (rows). The camera tool...

I have a workbook with some tables where I want to use the camera tool to put the tables on one report page for printing. problem is that when I activate this workbook the camera tool is disabled. If I copy a worksheet to a new workbook the camera tool is enabled. Also when any other workbook...

Hi, I am dealing with a spreadsheet (Excel 2003) with a lot of assumptions and which has ended up being quite a long one in terms of rows. However, the output of all those assumptions is in the firts few rows of the sheet and it is difficult to follow the overall effect when you change your...