kelvin_9

Active Member
Joined
Mar 6, 2015
Messages
444
Office Version
  1. 2019
if I have some photos stored with command button page
Is there any way that I can delete the photos only but not command button together by F5/goto/object

if no, any macro that can do it?
I had around 200photos in column F

thanks for the help
 
Last edited:

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK
Not that I know of.

Via VBA,

Code:
Worksheets("command button page").Pictures.Delete
 
Upvote 0
You can use the Selection pane (Home Tab, under Find and Select). After using the f5 special to select them all, you can then Ctrl+Click the button in the selection pane to deselect it.
 
Upvote 0
You can use the Selection pane (Home Tab, under Find and Select). After using the f5 special to select them all, you can then Ctrl+Click the button in the selection pane to deselect it.

any possible i can use macro too?
 
Upvote 0
Yes, if you want. Shg's code will not delete the commandbutton.
 
Upvote 0
Yes, if you want. Shg's code will not delete the commandbutton.

:eek:
i made a quick test on new sheet_command button page, but not working well(button will be deleted also), am i go for something wrong?
simply add 2 photos/create button/double click the button and add code/exit the vba dialogue/click that button again/ all gone. :confused:
 
Upvote 0
That is curious. Can you use a Form button instead? It won't have that problem (and is more stable anyway).
 
Upvote 0
That is curious. Can you use a Form button instead? It won't have that problem (and is more stable anyway).

sorry that, how to create "Form button"?
i have command button(activex control) in my quick access toolbar
 
Upvote 0
Change your options to show the Developer tab in the ribbon, then you can use the Insert dropdown on that tab.
 
Upvote 0

Forum statistics

Threads
1,213,536
Messages
6,114,210
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top