microsoft.public.excel | Forum profile

  Hi, 1. Open a blank document and select all the sheets. (grid line changes are sheet specific) 2. Click Save 3. Name the file Book 4. Change the Save as type to Excel Template or Excel Macro Enabled Template and 5. Save it to the \XLStart folder. This becomes the default workbook and the file that is opened when you start Excel or click the New button. -- If this helps, please click the Yes button Cheers, Shane Devenshire...

  Try: Private Sub CommandButton1_Click() If me.FilterMode Then me.ShowAllData End If End Sub ========== In xl2003 menus, I can add a ShowAllButton to my favorite toolbar. Tools|Customize|Commands tab|Data category Drag the "Show All" icon to your favorite toolbar. I like it since I can click on it in any worksheet in any workbook. dickharlo@gmail.com wrote: > > I'm trying to create a command...

  Notice a couple of changes =SUMPRODUCT((month(Sheet1!A2:A16202)=6)*(Sheet1!B2:B16202="4000")*(Sheet1!D2:D16202=1)*Sheet1!E2:E16202) -- Don Guillett Microsoft MVP Excel SalesAid Software dguillett1@austin.rr.com "philn" <philn@discussions.microsoft.com> wrote in message news:EC081FC6-7241-4BBA-9A30-70C22969FE03@microsoft.com... > Hi > > Reposting as still and...

  No, just the starting cell is fixed. You just change the number in B1 and it will take a new range. Of course that could be made automatic too, if it is imortant. -- Kind regards, Niek Otten Microsoft MVP - Excel "Paul Hyett" <vidcapper@invalid83261.co.uk> wrote in message news:zbEVc0dIb5YJFwpS@blueyonder.co.uk... > On Tue, 6 Jan 2009 at 13:40:45, Niek Otten <nicolaus@xs4all.nl>...

  With earlier versions of Excel you could set up a Book.xlt file with settings how you wanted them, and this is saved in your XLSTART folder - if it is there when Excel starts, then this is the file which is taken as the startup file, if not then Excel uses its own defaults. I'm not sure if this still applies to XL2007, but if you look in Help under startup and then "Customize the defaults for a workbook or worksheet...

  Other suggestions =IF(COUNT(Sheet1!D13:G13)>=2,J13+MAX(H13,$B$43),0)" or =IF(COUNTBLANK(D13:G13)>2,0,J13+MAX(H13,$B$43))" -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Nevets" <Nevets@discussions.microsoft.com> wrote in message news:3E5EBDD0-3E0D-4875-B6D5-77D342DB34BA@microsoft.com... >I have a formula in a cell...

  Consider a Pivot Table... http://www.contextures.com/xlPivot07.html In article <4f97de2b-fde7-4548-98bc-a179af5996ce@v31g2000vbb.googlegroups.com>, Guest3731 <notconfusedaboutthattoday@gmail.com> wrote: > Hi - here's the scenario: > > Column A is a person's name. > Column B is a date, e.g., 4/1/1979. > Column C is an amount of money. > > I'd...

  Thanks. Have sent a workbook over. Cheers. On Wed, 7 Jan 2009 10:58:49 -0600, "Don Guillett" <dguillett1@austin.rr.com> wrote: >Seems like a nice excel macro could do it quickly. If desired, send your >workbook to my address below and I will try to take a look.  

  A template is a workbook that you can use to create a certain look and feel for specific tasks, and when you open that template a new workbook is added with all of its attributes. -- __________________________________ HTH Bob "John Goche" <johngoche99@googlemail.com> wrote in message news:0de13bac-2108-46b3-8602-d7d4555e607c@r15g2000prh.googlegroups.com... > > Hello, > > I...

  Andy: I have no idea why, but it worked. Thanks, Craig "Andy Pope" <andy@andypope.info> wrote in message news:%23Rjez9ZcJHA.1916@TK2MSFTNGP02.phx.gbl... > Hi, > > The Crosses property set to xlMaximim should do it, > > '--------- > With ActiveChart.Axes(xlCategory) > .Crosses = xlMaximum > .TickLabelSpacing = 1 > .TickMarkSpacing = 1...