• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Pictures are messed up in file of 50 sheets

D

Dee

Member
I have created a template using macros in excel. I have given the option of adding the new sheet/template into the file.

In this template one can copy paste the picture. I have like that around 50 sheets/tabs in a file and each tab is containing minimum of 3 pictures.Every time we open this file all pictures in this file will be messed up. As it needs to go to the higher level i don't want to embarrass them with these messed up pictures.


Regards,

Dee...
 
Dee


Try the following, which should help


Select the Pictures and Right Click on Properties (Size and Properties in 2007/10)

On the properties page Select Don't Move or Size with Cells, then Enable the Locked button

Now enable Protection (Protect Sheet) and check that the Edit Objects is unselected


Also check that your macro isn't doing anything unexpected
 
You must log in or register to reply here.
Back
Top