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

  • AutoHotKey in VBA
  • 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

Recent Comments

  • Jack D. Slater on Golf Handicap
  • Utsab Subedi on Printing to a DYMO LabelWriter 450 from VBA
  • Utsab Subedi on Printing to a DYMO LabelWriter 450 from VBA
  • Dougal Scott on Excel VBA Code Cleaner Version 5.0
  • JimC on AutoHotKey in VBA
  • Jan Karel Pieterse on AutoHotKey in VBA
  • Dick Kusleika on Hyperlink Keyboard Shortcut Update
  • Michael Dias on Passing Arguments Through OnAction
  • Chris on Hyperlink Keyboard Shortcut Update
  • Gilles Wandoum on Cutting Stock Lengths

Archives

Categories

Meta

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