Excel Excel: How to detect an object in certain cells

Z

zenmate

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
 
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
 
Back
Top