Every time I type a number too large for a column, Excel resizes that column. This is definitively not what I want to do. I googled a lot and looked at all options, but I could not find a way to stop this behaviour.
how to disable any Autofit initiave from Excel 2010?
I am using excel 2010. When I click on cells on one column, something like text box will pop up with information related to that column. How can I get rid of this text box. How to disable this text box which I think it has a link between the text box and cells on that column.
Is it possible to disable Import Data Dialog box in Excel 2010? I have a web query file. I want to copy its content and paste in a new worksheet under an existing workbook. I have a macro which does that but I get Import Data dialog box when I tried to paste the copied content from test.iqy file to new sheet. The dialog box has
Select how you want to view this data in your workbook? By default Table is selected, which is fine.
Where do you want to put the data? By default New workbook is selected. I want to have Existing worksheet selected by default.
Is there a way to set these requirements into vba code and make this dialog box not appear at all?
We're setting up a test for candidates in an Excel 2010 workbook and want to get a sense of their native ability to spell. We'd like to disable spell check for the entire workbook. I've looked in Options>Proofing, even tried removing the dictionary, but haven't found a way to completely disable spell check from working. Is it possible to achieve? We'd settle for being able to disable spelling within a textbox.
I am trying to send bulk emails from my excel 2010 - however I am getting a POP UP. find the screen shot in the enclosed word document So every time a new mail is sent from excel we need to press the button allow Is there a way where I can turn off this warning.
Is it possible to disable all Excel functions? not as in disable calculation, but actually make Excel's standard functions not available in a workbook.
My reason for wondering if this is possible is that I would like to write UDFs that perform special actions in addition to the typical Excel functions, but give them the same name as their Excel counterparts... essentially create polymorphisms / overloaded Excel functions.
I have the code that accompanies the attached spreadsheet model that locks the copy, paste, cut, double click and so on, with the right mouse button and shortcut keys, however, the toolbar excel these functions still remain active. How well I block access to the toolbar.
I Have a spreadsheet in which data is spreading into column A-Z. I would like to disable copy, paste, ^V,^R,^C, ^D for certain columns (Q-U) of the workbook so that user is forced to enter data manually on these columns.
Currently I am working on a workbook where I am using a Save As VBA to create a folder and rename the file. The following code seems to be working fine so far with Excel 2007. Is there a way to confirm that it will work with all other versions of Excel and that my DesktopFolderPath String will work on all users machines?
In addition to these concerns, I am trying to avoid any Runtime Errors and currently, the Compatability Alert is the only thing I can see that is creating one. When it displays, in the event the user is unsure what to do, as most of our field staff is, and they select "Cancel" it displays the error Run Time Error.jpg. Can the Compatibility Alert be disabled? If so where do i add it in my code.
I am using Excel 2013. I have a spreadsheet that has a lot of very tall cells. When I use the scrollbar to scroll to certain parts of the spreadsheet it will automatically scroll up or down to the top of a cell. So if I want to view the middle of two tall cells that take up the whole screen it will automatically scroll up to the top of the highest cell that I'm currently viewing.
I just want to be able to scroll to where I want to scroll without Excel moving me up or down. I've tried to find answers on message boards but no luck.
I've just inherited a load of Excel files I need to continue using, but my predecessor has done something that disables the middle-click scroll ability.
I can still scroll up and down by turning the wheel, but I want to be able to click it and scroll in all directions at speed - I didn't realise how much I used this until I couldn't. Can't see anything in the VBA sheet properties, and they are all .xlsx files. Nothing leaps out of the settings either. If I create a new file or a file of mine within the same session, they work fine.
I am using Excel 2007 and I would simply like to autofit every column o that the information fits and is visible. I would do this myself, but when you have to open many files with as many as 100 columns, its not fun.
Is there a way / code i can put into a macro which can autofit a group of sheets or a whole work book. I have a workbook with 100's of sheets and it takes alot of time to click each sheet and autofit them manually.
I do run a macro for each sheet, so if i could build it into a macro by adding the code to it that would be great
I'm trying to Autofit a number of Rows within a macro. I need to autofit Rows 8 to 80 as the content of these rows will have been updated by lines earlier in the macro. Some rows will now contain more than 1 line of text whereas others will now be blank.
I have a range named "rngOrders" on an Excel 2003 worksheet. I'm looking for a VBA macro that will set the row heights of the range to autofit (for rows/cells with wrapped text) and also set a minimum row height of 19.5 points for all rows.
1. autofit all cells in 38 worksheets 2. copy the previous row without looking up or deleting or inserting. Just a simple copy previous row of values and formulas down one (to the next row empty or not) 3. Hide columns with headings hide in the first cell of the column.
Remember, I have 38 worsheets in the same workbook that it has to cycle thru. 4 of those are pivots, so no need to include those.