Skip to content

Daily Dose of Excel

Haphazardly Posted Excel Information and Other Stuff

  • About
  • Books
  • Consulting
  • Store
  • Checkout

Category: Templates

Book Template Constants

Posted on October 29, 2013October 27, 2013 by Dick Kusleika

I said I should do it. So I did it.

I created four workbook-level defined names in a blank workbook. Then I saved that workbook as Book.xlt in C:\Program Files (x86)\Microsoft Office 2010\Office14\XLSTART\. Now every new workbook will have those four named constants for use in formulas.

I put the chances that I will remember that they’re there/use them at about 20%.

Posted in Names, Templates 4 Comments

Advertisement

Search

Recent Posts

  • Macros with 32-bit API Calls
  • Name Manager updated
  • RefTreeAnalyser: Two updates
  • Opening a File from a Userform Disables Ribbon
  • Excel Virtually Global
  • Excel VBA Masterclass
  • International Keyboard Shortcut Day 2019
  • Combinations, Combinations. And the winner is…
  • Putting Statistics
  • Combinations, Combinations. A challenge

Recent Comments

  • Roger E Plant on How much faster is the double-VLOOKUP trick?
  • lewis morris on Converting an Excel Range to HTML the Hard Way
  • Andy on Draw a circle in an Excel chart
  • suh on Store
  • jesus on My Last Post on Filtering Pivottable Source Data
  • James R on Australia Summit for Microsoft Business Applications. (Oh, and Excel)
  • Cheri Tyler on Illegal Range Names
  • Robert Z on Circular References – The Good Kind
  • Noam Brand on Move Up/Move Down in a ListBox
  • worktime on Name Manager updated

Archives

Categories

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
Proudly powered by WordPress | Theme: sosimple by Fernando Villamor Jr..