vba to stop frame resizing

J

John P

Please can you offer a solution to a cell within a frame resizing. Is it
possible to fix it to a size in VBA so that it will not resize no matter
what occurs!

Cheers

John
 
J

Jezebel

No. There is no property that locks the size. You could write VBA to make
sure that its size is set to given values, and run that code periodically or
before saving the document or when the selection changes, etc.

What are you actually trying to achieve?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Place picture in Excel cell 0
Resize Problem 2
frame around the text and row numeration 1
Styles: one personal useful layout 0
How to adjust or resize a range? 3
Resizing picture frame/picture problems 1
Pass condition formatting across worksheets via vba. 0
Adjust cell size for long strings? 1

Top