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

  • 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
  • Where’s my “Edit Measure” option from the Values pane?

Recent Comments

  • Jovy Loh on Amortization Table
  • Colin Wheeldon on Crossword Template
  • Colin Wheeldon on Crossword Template
  • Colin Wheeldon on Crossword Template
  • Dick Kusleika on Joining Two Dimensional Arrays
  • Maduser1 on Joining Two Dimensional Arrays
  • Sangamesh Sharanappa Benigol on Merge data from different workbooks with the RDBMerge add-in
  • Darren Bee on Cutting Stock Lengths
  • Dick Kusleika on Adding ActiveX Controls to Worksheet in VBA
  • Jo on Adding ActiveX Controls to Worksheet in VBA

Archives

Categories

Meta

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