F5 goto object

[kelvin_9]

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

 

[shg]

Not that I know of.

Via VBA,

Worksheets("command button page").Pictures.Delete

 

[RoryA]

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.

 

[kelvin_9]

Not that I know of.

Via VBA,

Worksheets("command button page").Pictures.Delete

the command button will delete also

 

[kelvin_9]

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?

 

[RoryA]

Yes, if you want. Shg's code will not delete the commandbutton.

 

[kelvin_9]

Yes, if you want. Shg's code will not delete the commandbutton.

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.

 

[RoryA]

That is curious. Can you use a Form button instead? It won't have that problem (and is more stable anyway).

 

[kelvin_9]

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

 

[RoryA]

Change your options to show the Developer tab in the ribbon, then you can use the Insert dropdown on that tab.