default

I don't like the look of the default action when selecting a cell or cells which is to draw a heavy border around it/them. Can this default behavior be changed for the entire application? (as opposed to a single workbook) For example, I would like cell borders to NOT be modified from their...

How would you round the number 2.33 up to whole number 3 instead of the 2. Power Query's default for 0.33 is to round down and I want to round up. Also, how would you wrap the ROUND function in a formula when adding the values of two columns. <colgroup><col><col><col></colgroup><tbody>...

Hey all! Does anyone know what the vba code is for the DELETE button that is on the default form in excel 2016? I've tried multiple codes to delete my current record but it ends up giving an error in the project. The default form delete works fine with no issues. I was just hoping to do it from...

Did some digging online and it looks like Excel after many years: Still will not open CSV files as CSV files by default. Everything is in one cell ignoring the CSV extension. You then have to trick it into using the Text Import Wizard. Why? Still has no way to set the Text Import Wizard...

Happy Holidays to all here! I have some hyperlinks on a sheet which work fine except for one which wont open in my preferred default browser (chrome) so I have to open it in another browser. Is there a way to direct that single hyperlink to open in a different browser to my default?

Hi all, I have a spreadsheet that has a summary tab with a list of customer, addresses, etc., and another tab that creates invoices from the summary. I wrote a macro that cycles through the table and creates and prints invoices to the default printer. That part works fine. I am trying to add...

Hello I am trying to automatically default some cells to a minus figure. I have seen you could do an ABS formula but wondered if there was an easier way? I only want to do some cells in the column as the others are positive figures. Thanks

Hi everyone, My boss wants me to make an order form in Excel. I have the drop-down menus all in place, but one of the menus has a selection that must default another menu to a specific selection. E.G: We offer wood furniture and one of the stain colours is only available in cedar, so if a...

is it possible to delete value without formula? i mean if cells contain formulas..i want them to stay as default..if anyone delete the cell. formula must stay as default is it possible with macro or any tips?

So I have an excel sheet that people enter time in military format. In the FORMAT CELLS, I have it set to CUSTOM -> h:mm I also have some calculations for time which are working fine. But I want to make sure that users are only entering numbers for time. So I went to data validation. When I...

Hi everyone I need to setup a table of content in the following format: 1. Introduction >>(Indent)1.1 Implementation >>1.2 Policy >>1.3 Test >>>>1.3.1 Testing1 >>>>1.3.2 Testing 2 So there are 3 levels of number format. However it is not included in the default format...

I have created a table that includes a development factor, the data type is number, format is percent, decimal places 0, default value is 1, validation rule is <=1 New entries into the table are being generated as expected, with a %100 value in development factor field, however any edits to...

Hi,I have a problem i'm trying to solve and I expect it will take someone 5 minutes to figure out,But not me, I am just learning Excel and its wonderful ways it can automate so much. =IF(TODAY()>E12,"Overdue",IF(TODAY()<e12,"ok",if(today()=e12,"due today="" "))) continues...

I am using sendkeys in a rather complicated macro to autofill 4 PDF documents based on excel source data. Because I am only able to fill, reset or print and not able to save the filled in documents, I would like to use the "Microsoft Print to PDF" printer to save the filled in PDF. I have...

Okay, the good news is what I've done works perfectly. The bad news is I don't know what I've done or, more specifically, I can't explain it to a third party. A brief description: Row 2 contains the months from inception. Row 3 shows the recovery vector for any cycle of new defaulting assets...

Hi I have a form. i need run a sub with textbox value as default values. something like this: Private Sub Submit_1_Click(Optional serial = TSerial_1.Value, Optional model = CModel_1.Value) but when I run it, an error occurred that you should use constant value. is there any way to fix it?

Hi There This is my first post :-) (And VBA newby) I found this code (did a little modifying) in this forum for a search in excel, works fine but can you help me on this one: How can show a message to the user when nothing is found? I added MsgBox "Niets gevonden" (Nothing found in...

I have many vba procedures which I've written over the years, several of which include print commands. I've recently started taking my laptop between offices and using different printers. What is really irritating is having to change the printer selection each time I do so - it's very easy to...

Hello, I was trying to change the language for my Excel workbook and encountered a problem. If I just change the language from Dutch to English in the settings menu I have to choose to make it the default language, but is there a way to just change it for that particular workbook? If I choose...

I almost always want text boxes to keep their size and location regardless of what happens with the surrounding cells. So I end up manually right-clicking the border, selecting Size and Properties, clicking Properties, and clicking Don't move or size with cells. This page says that I can set...