Excel Excel: How to detect an object in certain cells


Joined
Nov 16, 2015
Messages
1
Reaction score
0
Hi,
i currently design a template form, the user must insert the logo photo (jpg) on certain cells (let say A1 : D4) , the system able to tell/prompt an alert if the user not insert the logo after he/she save the file.

Pls help... i have been search a lot places...still search the solution.

kind regards
 
Ad

Advertisements

Joined
Feb 21, 2018
Messages
122
Reaction score
46
Executing this will pick each and every object in the current worksheet and perform action (e.g here we just delete)

Sub wipeoff()
MsgBox ActiveSheet.Shapes.Count
Do While ActiveSheet.Shapes.Count <> 0
ActiveSheet.Shapes(1).Delete
Loop

End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top