1. M

    hyperlinks in browser window default extensions

    <!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent>...
  2. M

    New Stable Style - Set For All New Workbooks

    Hi, Excel 2010 I have searched for this problem and for others that may have similar solutions, but without luck. Apologies if I have managed to miss something that will later seem obvious. I am trying to design a new table style that can then be used in all new blank workbooks. I have...
  3. F

    "Save files in this format" setting keeps changing.

    I am having trouble getting Excel 2007 on my work computer to save as .xlsx by default. I have opened the Office Button > Excel Options > Save > Save files in this format and selected "Excel Workbook (*.xlsx)," and if I save as before closing Excel then it works perfect and saves the file as...
  4. E

    Command Button to return a default text

    Hi! I need to know when the command button is clicked, it will return a specific text or number... Like when I need to click "RESET BUTTON", it will clear the contents is the given range with this code: Private Sub CommandButton1_Click() Range("c8:c42").ClearContents End Sub But what will be...
  5. S

    Excel 2010 - setting up automatic recalculation

    In Excel 2010 a default safeguard is in place that sets all Excel files received by e-mail to manual recalculation instead of automatic recalculation. I know how to change each sheet manually (File, Options, Formulas, Automatic Calculation) but is there a way to remove this safety feature...
  6. SteveInAlabama

    How to trigger event when accepting a default cell value?

    My app has a range "rProductionInput" to allow operator entry of production information for each production run during their shift. I am successfully using Worksheet_Change for all the empty cells in a row to move the cursor to the right as well as other associated code I want to run. My...
  7. A

    Make cell style for all workbooks

    I made a few cell styles pretty easily that I planned to use for all of my spreadsheets. How can you have a cell style show up in the cell style dialog box in all spreadsheets, not just the ones that have that style? I see that you can paste in a group of cells with those styles, but I'd like...
  8. T

    VBA to ALWAYS see six default colors

    I'm making presentations all day at work. A ton of graphs in excel 2003. I'd like to write VBA, on the global level (meaning its always 'on' whenever I use excel) that makes sure there are six default colors in my palette. So that whenever I want to modify a bar chart, and I pop into the...
  9. M

    2007 Default Password

    Ahoy there ladies and gents. I'm a fresh n00b from Australia and found you when looking for a solution to what is probably a n00b error. I am using Excel 2007 (which was added to my customers intranet with the office 07 suite) and it automatically protects my worksheets with a password. I...
  10. E

    Specify chart template size - Excel 2007

    When I create a chart template in Excel 2007 and then use the template to create a new chart, the new chart size is always a default 3.0" X 5.0". Even if I 'Save As Template' at a specific size (e.g., 4" X 6") the new charts are still generated at the default chart size (3.0" X 5.0"). Does...
  11. R

    VB: default cell formula

    Is there a way to assign column cells a formula that references other cells in VB. I have gotten around this by running a macro that copies the previous cell formula from above and pasting it on line below. that method has flaws that I can no longer use. The idea is to make cell C2 = B2*A2...
  12. J

    strange currency format behaviour

    My default currency is £. I have a column of numbers formatted to £. the next column is a formula that multiplies the £ column by the exchange rate for Brazilian reais R$. When i format that column to R$ the first column changes the format to £$,that is a pound sign followed by a dollar sign...
  13. J

    Access 2007 Default = Now() > "Compile error. in table-level validation expression."

    Access 2007 I added a field to a table and went to save and received the following error "Compile error. in table-level validation expression." On investigation found I had a date field that had Default property set to Now(). Removing the default allowed me to save the table. I have been...
  14. 3

    Have both Excel 2003/2007.. how to open all files in 2007 by default?

    Hello, fellow Excel nerd here experiencing an issue I can't quite get around. I use Excel 2007 on my workstation at my job pretty extensively, it also has 2003 installed on it. Never had any issues with either. My xls files always used to open with 2007 by default which is what I preferred, but...
  15. D

    Help with Data Validation and Vlookup

    I've searched all over and can't figure this out. I'm making a spreadsheet where I want the user to select an item in A1 from a List made using Data Validation. When the person makes the selection in A1 I want the next 5 columns to automatically display specific attributes that belong to A1...
  16. V

    Show Pivot Table differently than it's default

    Hello All, I am very new to Pivot Tables. They seem very powerful, but yet, I can't seem to get them to appear the way that I want them to. Here's my issue... Here is my data... EXAMPLE 1 <TABLE style="WIDTH: 222pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0...
  17. S

    Validation Prompt Default Location

    I am using valadation in a column of cells wsed to input data to prompt the user with lists, choices, and instructions. It works great with one problem. The prompt's default location is directly below the cell and I want it to the right. It can easily be clicked on and dragged to the right...
  18. B

    Change formatting on new worksheet

    Hi. I am trying to change the default font and number format for new worksheets I create by right-clicking on the tabs at the bottom of the workbook, choosing insert and then selecting "worksheet" (all my other custom templates come up in this window too). The help on Excel is scant, I have...
  19. T

    Changing the default on a find

    When I type "Cntl F" in Access the default is "Whole Field" which I rarely want. I almost always need to change it to "Any part of the field." Does anyone know how I can make "Any part of the field" the default when I type "Cntl F?" Thank you in advance
  20. C

    Edit Data series color without data

    Hi, Currently I'm building a template excel file for my company and therefore have no data. The file also should include charts bsaed on future data. However Excekl uses a third line color yellow which is hardly noticable on a white background. I don't want to change the background but the...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back