Resources

    All about Visual Basic for Application (VBA) especially for Microsoft Excel.

Subscribe

  • Subscribe

Hide images together with rows or column in excel

Posted by | August 21, 2013 .

Sorry, no post since January 2013! Too busy and eye problem caused by computer I think.

This morning my friend asked? He got image in excel sheet but he wanted to hide when rows or columns affected is hide. After he tried several time the image still there.  Actually the solution is under image property itself, when we select image, right click and choose “size and properties” and again under “properties”  tab we have selection as below.

  1. Move and size with cells
  2. Move but don’t size with cells
  3. Don’t move or size with cells

These 3 selection is the setting what we can do or don’t to your selected image?  In this case we have to select (1) as option.

Under the same tab “properties” we have another selection as below for image.

  1. Print Object
  2. Locked

If selection (1) is unchecked your image disappeared when print but not in excel sheet. For option (2) this locked function available when excel sheet is protected otherwise remain unchanged.

If you have any question or project please e-mail to me, I will reply and create for free depending on my free time.
Click Here to E-mail
Or
Click here to get your project done with 5 Dollar
Thanks

Share Button
Share on Facebook
Bookmark this on Digg
Bookmark this on Yahoo Bookmark
Bookmark this on Google Bookmarks
Bookmark this on Delicious

Leave a Comment

If you would like to make a comment, please fill out the form below.

Name (required)

Email (required)

Website

Comments