View Full Version : VBA: How to prevent chart / picture / button from moving in Excel?
jadgon
11-17-2017, 03:26 PM
Hi,
I have an image name table.png and I need to fix it in the upper LHS.
I have to see the table and enter data in rows while scrolling based on column A values.
Logit
11-17-2017, 08:23 PM
.
Look at the Menu Bar items for VIEW / FREEZE PANES
jadgon
11-18-2017, 02:33 PM
I already tried that.
Logit
11-18-2017, 03:11 PM
.
See the attached :
jadgon
11-18-2017, 03:57 PM
Thank you.
Yes I want to display an image (say the cats image) on the button face. Please help me with the code for "Sheet2: This macro keeps button in upper left corner of window (after left click)." I want to keep it in upper Right Hand Side. PS: Sheet2 macro is not working.
jolivanes
11-18-2017, 04:42 PM
Re: I have an image name table.png and I need to fix it in the upper LHS
Place picture where you want it.
Right Click on Picture
Size and Properties
Properties
Select "Don't Move or Size With Cells"
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.