Must Have Things for XL2000

Location:   http://www.mvps.org/dmcritchie/excel/xl2kmust.htm
Home page: http://www.mvps.org/dmcritchie/excel/excel.htm
[View without Frames]

Automatic Calulation lost due to Addin

The following addition to your Auto_Open will guarantee that you have automatic calculation. 

Sub auto_open()
    If Application.Calculation <>: -4105 Then
       '-4105 automatic, -4135 manual, 2 semi-automatic
       MsgBox Application.Calculation
       Application.Calculation = xlAutomatic
       MsgBox Application.Calculation
    End If
End Sub

Auto_Save fix

MS has an XL2000 fix for not saving AutoSave settings
Q231117 - http://support.microsoft.com/default.aspx?scid=kb;en-us;Q231117 or download directly
    http://support.microsoft.com/download/support/mslfiles/ASUpdate.exe

The previous bypass had a problem if you included code in your Auto_Open and then turned off the AutoSave addin. 

    'The following line is used to turn off prompting in AutoSave Addin in XL2000
    'Result if addin is turned off: Run-time error '9'; subscript out of range
  ' Workbooks("autosave.xla").Excel4IntlMacroSheets("Loc Table").Range("ud01b.Prompt").Value = False
    'Jim Rech 1999-09-16, MS has an XL2000 fix for not saveing AutoSave settings
    'http://support.microsoft.com/default.aspx?scid=kb;en-us;Q231117
    'download: http://support.microsoft.com/download/support/mslfiles/ASUpdate.exe

Menu Maker

Obtain from John Walkenbach's site.  Allows you to create a menu built up from a spreadsheet.  See tip 53??

Table of Contents

see my home page
You are one of many distinguished visitors who have visited my site here or in a previous location  since Sept 17, 1999. 

Visit [my Excel home page]   [Index page]   [Excel Onsite Search]   [top of this page]

Please send your comments concerning this web page to: David McRitchie send email comments

Copyright © 1997 - 2004,  F. David McRitchie,  All Rights Reserved