Inserting an image into a cell and have a toggle button?

KathyK71 

It looks like your sister is using the "Camera" tool in Excel, which allows you to create a dynamic link to a range of cells, and then you can toggle the display of that range with a button. Unfortunately, the "Camera" tool is not readily available in the ribbon in recent versions of Excel, but you can add it to your Quick Access Toolbar to make it accessible.

Here is a step-by-step guide on how to use the Camera tool and add it to your Quick Access Toolbar:

1. Adding the "Camera" Tool to the Quick Access Toolbar:

1. Right-click on the ribbon and select "Customize the Ribbon."
2. In the Excel Options window, choose "All Commands" from the "Choose commands from" drop-down list.
3. Scroll down and find "Camera."
4. Select "Camera" and click the "Add > >" button to add it to the Quick Access Toolbar.
5. Click "OK" to close the Excel Options window.

2. Using the Camera Tool:

1. Select the range of cells (including the image) that you want to link to.
2. Click on the "Camera" icon in the Quick Access Toolbar.
3. Click on the cell where you want to place the linked image.
4. The selected range is now linked to the cell, and any changes in the original range will be reflected in the linked image.

3. Adding a Toggle Button:

1. Go to the "Developer" tab. If you don't see the "Developer" tab, you can enable it in Excel Options.
2. Click on "Insert" in the "Controls" group and choose a "Button" from the ActiveX Controls.
3. Draw a button on your worksheet.
4. Right-click on the button, select "Properties," and set the following properties:

• Name: ToggleButton1 (or any other name)
• Caption: Toggle

1. Close the Properties window.
2. Right-click on the button, choose "Format Control," and go to the "Control" tab.
3. In the "Cell link" field, enter a cell reference (e.g., A1).
4. Click "OK."
5. Assign a macro to the button (right-click, "Assign Macro") and choose a macro that will toggle the visibility of your linked image range.

Here is a simple VBA code for the toggle functionality:

Sub ToggleImage()
    If Range("A1").Value = 1 Then
        Range("YourLinkedCell").Rows.Hidden = False
        Range("A1").Value = 0
    Else
        Range("YourLinkedCell").Rows.Hidden = True
        Range("A1").Value = 1
    End If
End Sub

Replace "YourLinkedCell" with the actual reference to your linked cell range.

Now, when you click the button, it should toggle the visibility of your linked image range.

The text, steps and code were created with the help of AI.

My answers are voluntary and without guarantee!

Hope this will help you.

Was the answer useful? Mark as best response and Like it!

This will help all forum participants.