• 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.

Protecting Graphics in a cell

Busymanjohn

Busymanjohn

Member
Hi guys, I have been looking for a way to protect certain graphics within a worksheet, but failing. I have a sheet with cells populated with various data and I am protecting only certain cells within the sheet, however, some of those cells I am protecting also contain graphics or images and I would like to be able to protect those as well as the cells .... any ideas on how to protect the graphics so that a user cannot click on them or move them around ?
 
Hi


Have you tried selecting those objects (graphs / images) and setting the object properties to:

1. locked

2. Move but dont size with cells (or as applicable)


This should do.


Regards,

Prasad DN
 
Hi prasaddn, that's not enough, however, I did play around a little and found that when protecting the sheet in the pop up box uncheck Edit Objects, this protects all objects as well, but thanks for the reply as always.
 
You must log in or register to reply here.
Back
Top