resizing

I have several buttons on on work sheet. At some point, they decide to start resizing themselves. AN internet search seems to indicate this is a common problem. I am not married to command buttons is there an option for these macros that would avoid the automagically resized buttons. Ian

I have pictures already pasted into excel cells. I just want to write a macro that will let me change their sizes when I select them. I don't want to paste any new ones and everything I try gives me a 438 error object doesn't support this.

Hi, I probably need a for loop for this, I have a table which has the range A1:J500 and a lot of it is formulated. It can get slow after resizing and data increases, so I was wondering thinking I could turn formulas into values once the row is filled and no longer needs changing Would this...

Hi, I have a table formula which uses a vlookup on the above cells, like: =vlookup(F99,$A$2:C98,3,false) When I resize the table, to example row 500 (default size is 100) All the rows formulas are correct except row 100 which shows after resizing: =vlookup(F99,$A$2:C500,3,false) Obviously...

Hello, I have a stacked bar chart in Excel with a Right Brace for two of the 4categories. Is there a way to automate the resizing of the Right brace to matchtwo of the four categories? As I mentioned it’s a stacked bar chart. Categoriesare Red, Blue, Green, and Yellow. The Right bracket is...

I get increasingly annoyed with resizing column width in pivot table every time when I drag new field or calculation. My header names go 'funny' and I have to spend time to change width of each column so they are readable again. It is just really annoying. Google says to un-check "Autofit...

Hi, This may be a little difficult to explain, so please bear with me. I recently switched from Excel 2003 to 2013, and have noticed that 2013 seems to handle image resizing and/or clipboard output a little different to 2003. In Excel 2003, I was able to paste an image (screen shot) from the...

Hi, I've searched for an answer for a while now. And according to my research it is not possible to resize an individual cell, without resizing the entire row/coloumn. I'm posting here to validate my research, which is telling me that it is in fact not possible. :) Thanks in advance

Hello guys, I have one little problem. If I format some data as table, down there in right bottom corner is blue (if table is blue) triangle, which should be used for resizing table. My problem is, that I am not able to use this triangle, there is just cross when I point the mouse on it...

Hello, I've been reccomended here to ask about a problem that I just can't seem to find the answer for. I've tried searching google and in-fact everywhere and I can't seem to find a way to fix my problem. Basically I've built a pivot table, and whenever the filters are changed, or the pivot is...

I have worksheet with an embedded Word document. I used the Word document to write summaries with full formatting and spell check. The issue is that the if the text of the summary has more or less lines than it did before it was edited, the embedded object gets resized internally(that is the...

Morning, Wondering if anyone can help me with this. I am trying to copy an image from a website, then pasting it onto excel, resizing it, and crop it (have to do it for 4 seperate images). Right now I have the script below. I've been researching and I know I have to use .picture.counter to...

I have a workbook with code that hides rows when I input a number in a designated cell. The print size is set to fit the the worksheet on one page. Is it possible to have a macro that would resize the info based on what is visible on the worksheet? i.e. The more rows with data I have would...

I have several workbooks with ActiveX command buttons which call userforms. Recently the command buttons have started shrinking or growing with every activation. As well, the font is smashed into a small point in the middle of the button. I have changed properties, text size, font, deleted...

I created a new chart as part of an 80 chart file. The new chart is so large that the Chart Title is inside the Chart Area. The Horizontial Axix Title is not visible. When I right click to make adjustments, I see a dimmed autofit box when I click on Size. Where do I find the settings to make...

Is it possible to have a userform resize like when you click on the bottom corner of a picture and drag it to resize to whatever size you want it to be.