|
Feedback:
Please write to us
|
| |
Templates from microsoft
http://office.microsoft.com/en-us/templates/default.aspx |
|
|
How to troubleshoot errors when you save Excel files
http://support.microsoft.com/default.aspx?scid=kb;en-us;271513 |
| |
Excel Does Not Run on Multiple Processors
http://support.microsoft.com/default.aspx?scid=kb;en-us;265361 |
|
|
Remember XLM? Here is the helpfile download:
http://download.microsoft.com/download/excel97win/utility4/1/win98/en-us/macrofun.exe |
|
|
You can find the documentation for the Excel 97 SDK online at:
http://msdn.microsoft.com/archive/
then:
Office Solutions Development
Microsoft Office 97
Office 97
Product Documentation
Excel
Microsoft Excel 97 Developer's Kit |
|
|
Increase the number of undo levels in Excel
http://support.microsoft.com/?kbid=211922
| 1. |
Close any programs that are running. |
| 2. |
On the Start menu, click Run. Type
regedit and click OK. |
| 3. |
In the Registry Editor, expand the following key:
HKey_CURRENT_USER\Software\Microsoft\Office\9.0\Excel\Options |
| 4. |
On the Edit menu, point to New and
click DWORD Value. With New Value #1 selected, type
UndoHistory, and then press ENTER. |
| 5. |
On the Edit menu, click Modify. In
the Edit DWORD Value dialog box, click Decimal under
Base. Type a value between 0 and 100 for Value. Click
OK and quit the Registry Editor. |
| 6. |
Start Microsoft Excel. Microsoft Excel stores an
undo history for the number of actions you specify in step 5. |
|
Using sendkeys:
More then 16 sheets, then show activate dialogbox else popup sheet name.
Sub SheetActivate()
'assign shortcut Key
If Application.CommandBars("workbook tabs").Controls(16).Caption _
Like "More Sheets*" Then
Application.SendKeys "{end}~"
Application.CommandBars("workbook tabs").ShowPopup
End Sub
|
| |
Using the auditing toolbar ...
A red arrow indicated the problem
If there is not a range reference in the statusbar, you could be on the
wrong sheet.
As each reference "resolves" itself, through the calculation engine, the
error moves forward and a range reference will then appear on other sheets |
| |
|
External links may update when you open a file that was last saved in a
previous version of Excel |
| |
'' *******************************************************************
'' Purpose : Test whether an add-in is in memory
'' Written : 14-Feb-2005 by Andy Wiggins, BygSoftware.Com
''
Function IsAddinLoaded(pStr_Name As String) Dim lObj_AI As AddIn
IsAddinLoaded = False
For Each x In AddIns 'Workbooks
''Debug.Print x.Name
If UCase(pStr_Name) = UCase(x.Name) Then
IsAddinLoaded = True
Exit Function
End If
Next
End Function
|
| |
|
OneDesk: Global implementation of uniform desktop environment |
| |
''***************************************************************************
'' Purpose : Acts as if you've pressed Ctrl + Home
'' Written : 05-Aug-2004 by Andy Wiggins, Byg Software Limited
''
Sub ScrollToHomeCell()
ActiveSheet.Cells(ActiveWindow.SplitRow + 1, _
ActiveWindow.SplitColumn + 1).Select
End Sub
|
| |
MSDE - Home Page
http://www.microsoft.com/sql/msde/default.asp
Northwind Samples
http://www.microsoft.com/downloads/details.aspx?FamilyID=06616212-0356-46a0-8da2-eebc53a68034&DisplayLang=en |
| |
MSDE - Home Page
Northwind Samples
|
| |
| |
Published: 20-October-2004
Last edited:
01-Apr-2007 19:11 |
|
