Hello, Question continue.

I have example five pictures and they all have link targeted sheet 2.
When user going to change sheet 2 name links go down.
User can create more than 5 pictures example 6.
I think it that solution right this way:
-> User create picture---VB makes log "name"+"target sheet, link"
-> User change sheet 2 name---Coming msg which warning about link broken
-> Yes button----VB check out log, how many pictures there is and after it going to change them all right one.
-> No button----- cancel and change not happening

If any of you have some parts to make this true. pls write it down.