PDA

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"