Windows Secrets
Windows Secrets Lounge
Read one Cell and Execute Action (Excel 97)
Paste Word Text in Cell (Office 97)
Auto sizing of charts (2000)
ImportWizard (Excel 97)
Restricting cell contents to numbers (XL 2000)
Data Labels on XY Charts (Excel 2000)
Multi Select with GetOpenFileName (97/2000)
coloured bars (Excel 97 SR2)
Unprotecting Multiple Sheets (2000)
Macro to Create Dates from Date-1 to Date-N (OFFICE97 SR2)
Displaying time per distance (2000)
Customized Functions (2000)
Autofilter (Excel 2000)
A Save in time (Excel97-SR2)
Disable Macros (97 SR2)
Open Word doc from vba (Excel 2000/SR2)
Charts (Excel 97)
Sort, Pivot Table, or What? (Excel 97 SR-2)
Lookup (2000)
automatically lock a cell (excel 97)
Custom cell format? (2000, SR-1)
UserForm / ComboBox (Win 98 XL2002)
Outsourcing an Excel project (Excel 97)
Statistics using Excel (Excel97)
Excel Page breaks (Excel 97 (SR-2)+ 2K 9.0.4402 (SR-1))
DMAX ?? (Office XP)
Hyperlink navigation on same sheet (Excel 2K)
Finding Embedded Links (2000)
Function For Days In Month (2000)
Referring to toolbar controls (2000)
Pivot table help for beginners (Excel 2000 SR1a)
no more custom format numbers can be added (97)
Setting up a Spreadsheet for Pivot Tables (2000 SR1)
Pop-up lists (Excel97 with Win98SE)
Macro help request (Excel 2000)
Fonts for Column/Row Identifiers (Excel 97-SR1)
COUNTIF or SUMIF (Excel 2000 SR1)
tab name equal to cell value (97)
Shaded area doesn't print correctly (Excel 2000)
Month function (Excel 2000 SR1)
Full Path Name and Doc Name in Title Bar (97SR2 or XP)
.SendMail and multiple recipients (97sr2h)
Working with date and time (2000)
Shareable Workbook-Options (Excel97-SR2)
System Crash/Reboot Coverage (97 SR2)
Controlling Toolbars (97 SR2)
Nimda.E & Excel (97)
Simple piece of VBA required (Excel 2k)
Data Validation not working (Excel 97)
ADD-INN (Excel 2000)
Problem run diff machine of my VBA/Excel (Excel 97 and 2000)
Print Area (2000/SR-1)
Slow linked workbooks/sheets and Jini (97)
Comparing Cells (Excel2000)
Filter a listbox (97 SR2)
Expand Excel? (Excel 2000)
Formatting (Excel 97)
Sum on Visible Cells (XL97/SR2)
Sorting a Column (Excel 2000 SR1)
Progress Bar: Saving (97 SR2)
Macros (2000)
Conditional formatting (XL 2000)
Web Query (Excel 2000)
Identify any 'corner' cell address of selection (MS-Excel 2000 (9.0.3821 S
Excel template directory (XP)
Open Dialog (Excel 97 and >)
Select Case and Currency (Excel 97)
Significant digit limitation (Excel all versions)
Does a number exist in an array (Excel 2000)
Calculating Elasped Time (2000)
Hyperlinks in Excel 97 (Office 97 SR2)
PasteSpecial class failed. (Excel 97)
New Records in Data Forms (Excel 97)
AutoFilter Excel 2000 (Excel 2000)
Data Validation List Box (Excel 97 SR1)
Automatic e-mail (Excel 97)
Advance Filter (Excel 2000)
copy paste worksheet (Excel 2000)
Excel (Excel 2000 SR1)
Subtotal method, breaks= true, fit to 1 page wide. (xl '97 vba)
User has macro that she views a flash
Combining cells in Excel (Excel 2000)
Removing an Item from ListBox (2000)
Data Validation (2000 SR-1)
Default page setup (Excel 2000)
Copy and Paste - INCLUDING COLUMN WIDTHS! (97 SR-2)
Conversion from 97 to 2000 (97 SR2 to 2000)
VLOOKUP Limitation (XL2000)
The Toolbar that won't die (Excel 97 (SR-2))
Insert Spaces (2000)
Accessing WB w/out Open (O2000SR1)
Info on xldialogs (O2000SR1)
Importing Form 2nd WB (O2000SR1)
Convert Word Tables (Excel 97)
Dates (97)
Limited Access to Trial Workbooks (Office 2000)
Worksheet (Excel 2000)
Run a macro when cell is entered (Excel 2000)
Insert rows & Nonblank cells (2001)
Concatenating a 'New Line' character (Excel 2000)
Hiding Personal.xls (98)
Cell Comments (97- SR-2)
Calculating Intersections in a Chart (Excel-Office 2000-SR1)
Record LogOn/Off (Excel 97)
Dimensional Fractions (Excel 97 SR-2)
Problem running sql in excel (Excel 97)
Adjacent Dependent Validation Lists (Office97 SR2)
Execute Code at Window Restore (97 SR2)
Add line to Stock Chart (XL 97 )
Nested If Statements (Excel 97)
Importing Text Fields (97/2K)
Addin corruption (Excel 97)
SelectionChangeEvent (I think) (E2000)
UnBound Listbox Headings (Excel97)
Macro Launch Keys (Excel 2000)
Editing a protected worksheet XL2000 (Excel 2000)
one sheet referencing several sheets (97)
make a list (Windows 98SE)
Quick Delete (Excel 97)
How do I start excel from a Script Shell (Excel 97 & 2000)
DisplayFullscreen=False doesn't work (Excel 97/2000)
Pareto Chart (Excel 97/2000)
Instead of 65536 (2000, SR-1)
Sharing Violation (Excel 2000)
Listbox items (Office 2000)
pairing up (excel 97&2000)
Changing Colour of Cells (Excel '97)
Delete Macro (Excel 97)
Excel (2000)
SUMIF Formula (Excel 97)
Reading Contents of Cell (Excel 97)
Linking one worksheet to another (Office 97 Pro SR2)
Extract first line of data group (XL 97)
Delete files in VBA (97 SR2)
posting a current date in macro (2000)
Paste macros (2000)
lots of rows (Excel97 SR-2)
marco ask for current mont (2000)
Directory Access (97 SR2)
Excel 'sub' worksheets (Excel XP)
Listbox Coloring (97 SR2)
Listbox Rowsource (97 SR2)
ISERROR Function (Excel 97/2000)
Excel problem (2000 SR1)
Graphing data -- Excel or Access? (2000)
Importing email addresses from Excel into Outlook (Office 2000)
Pivot Tables - totals(sum) vs count?? (Excel 2K)
Starting Excel Changes Clipboard (2000 SR-1)
Chart title linked to a cell (Excel 97/2000)
Sorting Blank Cells (Excel 2000)
Blank Workbo (Excel XP)
Please Help .....Dynamic Named Range (Excel '97)
Macro sending current wb (XL2000 SR-1)
Histograms and Class Frequency (97)
Special Cell List (Excel 97)
Excel98/PowerPoint 98 MS01-050 (Office 98)
Turning off automatic hyperlinks (2000)
Range to Print (Excel 2000)
Macros in Excel (Excel 2000 SR-1)
Alignment (exel 97 & 2000)
Breaking Links (Excel 2000/1)
06E0 triggers garbage in cell (Excel 2000)
Adding round function to existing formula (Excel 97 SR1)
Excel and Adobe Acrobat (Excel97/Adobe Acrobat 5)
Datevalue (2000)
Message Box (Excel 97)
Pasting Formatted Text (Excel 2000 SR1)
Excel Workbooks being corrupted (Excel 97)
Saving a Function (Excel 97)
Pivot Tables - Copying to a static file (Excel 2k 9.0 SR1)
Multiple line footers (Excel 97)
Average of several dates (97 SR2)
Reading Blank Data (English)
Userform Page Tabs (97 SR2)
Protecting a Cell's Value (Excel 2000)
Chart colours disappear (XL XP (2002))
Charts in separate window (97,2000, XP)
Update Links (Excel 97/2000)
Sum figures based upon text in bordering column (2002)
Range failded (Excel 97)
Search via Userform (97 SR2)
UserForm (Excel 97)
Sub Workbook open() & Worksheet_SelectionChange (Office 97 SR2)
Copying Info from one worksheet to another (Excel 97)
title bar missing (office 2000, win 98)
TXT to NUMBER? (2000 SR1)
XL97 Chart in XL2000 (2000)
Edit/Fill/Justify loses word separations (Excel 2000)
Disallow Typing for ComboBox (2000)
Excel to Outlook 2000 (Excel2000)
SumIF Accross Sheets (97/2000)
Calculating time ... (XL97)
Year planner (97)
Start VBA at Startup (97 SR2)
Link tick box to todays date (O97/O2K)
Formula Help - Re-Post (Excel 97 SR2)
Restore button minimizes instead (Excel 97 SR2)
Formula Help (97 SR-2)
unwanted conversion to dates (Excel 97 SR2)
Conditional Format to mutli cells? (Excel '97)
Cycle thru 5 WS with a copy, paste, print macro. (EXCEL 97 SR2)
Distributing a Toolbar Button and Macro to users (Excel 2000 / 97)
vlookup equations (excel 97)
Getting the first Character of a String (2000)
Copying Toolbars (Excel 2000 SR-1)
Range data type, Selecting a column (2000)
Recently Used Files (97, 2000)
Pivot Table - Ordering Text Data (Excel 2000 )
Links and replace data (Excel 97)
Excel crashes (Office 97 SR-1)
Change Management (2000)
putting records into a class (97)
Data Validation circumvented by data forms (Excel 97/2000)
Replace Text (Excel 2000)
eMail Macro (Excel 97, Outlook 98)
Nested conditions (Excel 97)
Excel Gridlines (2000)
Formula Bar (Office 97 SR2)
payment comparison? (Excel 97)
Counting number of weeks in a period (Excel 2000 SR1)
Finding Sum of X in a column (Excel 97)
Automation problem(Excel/Access) (2k)
Cell format protection (Excel 97 SR2)
excel searching (excell 97)
Adding A1 in ALL worksheets. (97)
AttachedTemplate.Path property for Excel? (Excel 97/2000)
Animated Pictures (2000)
Error trapping with Find Command (Excel 2000)
Copy Comments (2000)
Column width (97)
Macro to run when w/b opens (Excel '97)
Looking up a cell from user input (Excel 2000)
Save As Program Error (97 SR2)
Button Color (Excel 2000)
IsNothing (97)
LSD (Excel 2000)
Assigning styles to buttons (2000 SR-1)
Recovering from corruption (Excel 97 SR-2)
Concatenating (Excel 2000)
Custom Date Formatting (Excel 2000 SR1)
Calculate diff between dates (97)
Grouping/calculated items in pivot tables (2000)
Full pathname in Footer (Excel 2000)
Charts (Excel 97)
Memory recovery in Excel (Excel 97 SR-2)
Cell Name (2000 SR1)
Incremented Footers (2000)
Line charts don't display or print correctly (2000 and XP)
Excel/Power Point Patch (Office XP)
Footnotes (XL97 SR2)
Find/Replace dialog box changes (Excel XP)
Templates From Msft Website..?? (xl xp)
Formatting the difference between two times (97)
If statement (97)
EX2K Security patch executable file (EX2K)
Macros|Security|No virus scanner installed? (Excel 2k (9.0.3821 SR-1))
Shortcut in Excel 97 (97)
Concatenate (XP)
Snaking columns in Excel (2000 SR-1)
Start up macro? (Excel 2000)
Array formula (Excel 97)
Autofilter shortfall (Excel 97 SR2)
Drop Down Menu (Office 2000)
text frequency distribution (2000)
Freeze display (2000 SR1)
Random Number (97 SR2)
AutoMacro & command button (Excel 97)
Another Pivot table coding (97)
Pivot Table coding (97)
Stuck in Select (2000 9.0.3821 SR-1)
print current page (Excel 2000)
Returning co-ordinates of the active cell (Excel 2000)
Dialog Sheet? (Excel97 SR2)
Post-Patch version number - MS page wrong? (9.0.4402 SR-1 (???) (Excel 200
Printed display not correct (Excel2000)
Creating and calling functions (Office 2000)
Lack of MS Support for Excel 97 (Excel 97)
Creating Forms (Excel 97)
Cell borders don't print on second copy (Excel 97/SR?)
Cycle Through a List Of Query Parameter Values (Office97 SR2)
Placing a SINGLE value into a cell (Excel 2000 SP1)
Rename a sheet - keyboard short cut (MSO97)
Weeks (97b)
Macro Problem - Saving Open spreadsheet (Excel 97)
Auto increment a list of numbers (Excel 97 SP2)
Saving Sheets as Files (Excel 2000)
Finding items based on criteria (2000, SR2)
Group Box Format (Excel 97 SR1 NT4)
Vertical Scrollbar Problem in Shared Wkbk (Excel 2000)
Rounding Figures in Excel (97 SR2)
Selection.SpecialCells (XL97Sr2h)
Active Cell (cursor) color (Excel 97)
Windows login name (97)
Formatting a single-precision value (Excel 2000, SR1)
Commas in Excel .csv files (Excel 97 SR-2)
Large scale printing (Excel97 SR-2)
Font color for worksheet tabs (2000)
VBA Copy/Paste Question (2000)
count text differences between two cell (ranges) (Excel 2000)
random lists (excel2000)
Adding Date to a Specific Column (Excel 97)
If statement (97)
Opening a HTML table in Excel (Excel 2000)
SAP Excel Intergration (Excel 2000/XP)
Subtotal Function under Tools (Excel 2000/XP)
Formula query (97)
ActiveX error when reading test file (Excel 2000)
Stack Dump (2000)
List Box... (2000)
dynamic named ranges (2000)
be prompted where I want to get/save a file (Excel 97)
.tif files to .xls format (2000)
SUMIF using 2 conditions (Excel 97)
Need help on count Fx (2000 sr1)
Multi-sheet report from Excel (2000)
VBA help screens (Office 2000)
Pivot Table Cache (Office97 SR2 & Office 2000)
Run Macro on event (excel 97)
Default Colour Schemes for Graph Series (XL2k sr1)
Default Summary Function in Pivot Tables? (Excel 2k sr1)
'Double Protect' (XL97/sr2)
File is being shared (not) (2000)
Weird Macro Behaviour (XL2000)
SelectionChange(ByVal Target As Excel.Range) (OFFICE 97 SR2)
Sorting array of data (97/SR1)
Convert Acrobat files to Excel Spreadsheets (2000)
Links closes spreadsheet! (Office 97)
2000/98 Windows Macro --> Run on Mac? (2000/98)
vba coding (97)
Sorting (Excel 2000 )
Getting information INTO a macro (Excel 97-SR2 on Windows 98)
Validation List (Excel 97 SR2)
Open File If Not Already Open (Office97 SR2)
Turn Button Red (OFFICE 97 SR2)
Want to break it (2000 SR2)
ASAP utilities (97/2000/XP)
Exporting information from Access (Office 97)
Send to / email recipient question (Windows98-SE, Office 2000, Excel 97)
Pivot table problem (97)
Creating a range name in VBA (Excel 2000 (9.0.2720))
SelectionChange (XL97)
Filename Truncation Problem (Excel 97 SR2)
Constants and functions (2000 sr-1)
Tab to next cell (XL 2000)
Function question (Excel '97)
Find text in comments (Excel O97 SR2)
Wise counsel sought! (Excel 2002 )
Macros and relative Cell references (Excel 2000 SR-1)
Don't know what to call it (Excel 97, SR2)
Referencing sheets with FORMULAS (Excel 2000 (9.0.2720))
Excel won' t launch (2000)
Print a quotation mark in a cell's formula. (2000)
Conditional Format (97 SR-2)
Using Array Formula (97/SR 2)
Using WinZip with Excel/VBA (Winzip 7> Excel 97>)
Link to source data always changes (Excel 2000)
Sheets('MASTER').Copy After:=Sheets(33) (97)
Trusted Macros (Excel 2k SR1)
Compare spreadsheets (Excel 2000)
Sorting (97)
Reverse Pivot (97)
Userform in Excel 2000 (2000 (9.0.2720))
To notbrl in Ref to Migrate to XL2002 (XL2000) (Excel 2000/2002)
Migrate to XL2002 (XL2000)
When opening a single file, it creates two copies! (Excel 97)
Macro Code ERROR (Office2000)
Auto Generate Numbers (2000)
Type Checking (2001)
Excel (Office 2000 SR1-Wint NT 4 (sr6))
Have cursor appear in a textbox (2000)
Vertical line between two dates (97)
Close workbook w/out saving changes. (xl97)
Referencing sheets with VBA (Excel 2000)
Not enough memory (Excel 97)
How do I get my Ranged area to excapand ? (Excel 97)
Excel defaults (Excel 97 SR-1, WIN 98 4.1)
cell too small (excel 2000)
ODBC Query (Excel 97, Access 97)
reformatting a multi-page double column listing (excel 2000)
duplicate keys (Office 2000)
Printing Non-contiguous columns/rows (2000)
AutoComplete - switch off (2000)
Compare values via formula (2000)
VBA Help (97 SR2)
Report writing? (Excel97-SR2)
VBA UserForms (Excel 2000)
Delete Cell Contents (97 SR2)
Linking multiple worksheets (Excel 97 SR2)
Graphics (Excel 2000)
SUM function does not adjust the bottom anchor (97)
Autofilter showing particular cell (Excel 97)
Missing Printers on Printer List (Excel 2000 SR1)
Auto Save (Excel 2K)
Auto_Open Macro failing (XL 95)
Excel 97 (SR-2)
Code Documentor (XL2000)
Excel Amortization Template (Excel2000 sr1)
Custom format in XP (OfficeXP)
VBA execute on close (Excel 2000 SR-1)
Pivot Tables (2000 win NT)
Scatter Charts (Excel 2000)
Lookup Question (excel 97)
Excel & Labels (Excel2000)
Paste Conditional Formatting (Excel 97)
Formatted Numbers & statements (2000)
Update Date (Excel 2000)
Lotus Notes and MS-Excel (97 SR2i)
Retrieve code from a busted macro? (2000)
Microsoft Examples (97b)
Automate routine (Excel 97-SR2)
Data ValidationDropdown Lists (Excel 2000 SR1a)
A simple piece of VBA (Excel 2000)
Spreadsheet doesn't update (Excel 97)
Lost trailing zeros (Excel 2000)
Path in Caption (XL2000 SR1)
Investment tables (97/2000)
Select Range With xlDown Doesn't Work (97 SR2)
Running Macros (Excel 97)
Neat random number generator (2000)
Data Validation, List offset (Office 2000)
ISIS for Excel hangs on Startup (XL2K; I4XL 1.1.6; Win98)
controlling Word from XL VBA (Ver 97/2K)
Colour fill/dollar format not working (2000)
Zeros in blank cells (97)
Echo Off (xl 2k)
Forms-Combo Box (XL97_SR2)
Unique entries in column? (97/2000)
Excel bug in COUNTA (97)
File Conversion Wizard (2000)
Page Break Preview (97)
Selecting Multiple Ranges (Excel97 SR2)
using #DIV/0 in formulae (2002)
Email links (Excel 97 SR2)
Extraction of "comments" fields? (Excel 2000 SR1)
Insert Simple "If" formula (2000--VBA)
Excel - Sorting (Excel 97 - SR2)
Polynomial Regression (2000)
Browse for file? (2001)
Shared Excel file (Excel 97, SR2)
Personal Macro Workbook (Excel 97, SR2)
Controling SQL from VBA (Excel 97 SR2i)
Countif across sheets (Excel 97-sr2)
Average using date criteria (Excel 97)
Excel lookups for Word gurus (2000 SR-1)
Cells show formula rather then result (2002)
compile error in hidden module (Excel 97 SR2)
Macros (95)
Charts (2000 SR1)
Sorting Times Using VBA or SQL (OFFICE 97 SR2)
Halt Execution while User Takes an Action (Office97 Sr2)
Autonumbering? (2000 SR-1)
Date Field (2000)
Linked Files (excel 2000/excel 97)
Sort (Excel 2000)
Settings problems? (97)
Formula Help Needed (2000 SR-1)
URL glitch (Excel 2000)
A near password-no brainer (Excel 97 SR-2)
XLM marco (Excel 97 SR2)
Excel hangs system (2000)
Manual Links (EXCEL 97/2000)
Excel97 SR2 Win98 (SR2)
Pivot Table or other method (2000/SR1)
sharing wB for set of users (xl97/xl2000)
Numbers vs text (Excel 95)
Undo not working (97 SR-2)
Connect to specific instance of Access from Excel (Excel 97 SR-2)
Sorting (97 sr -2)
Change time to general format (Excel 97)
Question About Excel (Excel 2000)
COUNTIF across sheets of a workbook (2000)
Add command to Tools Menu (EXCEL 97/2000)
Negative Numbers (Excel 2000 SR1a)
Absolute Sum (Excel97)
protect and unprotect (Office 97)
Loading a text file (Ex97/SR1)
Graphing Error in workbook
Exported spreadsheet contain ' (Excel 2000)
Copy Until Done (Excel 97 SR2)
freezing screen during "refresh all" (excel 2000)
External data from Access & relocation of database (Office 97)
"File Error: Data may be lost" msg opening wkbook (Excel 97)
Disappearing Sheet Tabs (97sr2 and 2000)
Cutomize Toolbar (office 97 SR2)
Convert Numbers to Words (2000)
Autofilter macro (Excel 97)
Win 95/Of95 (SR1)
#ref (2k)
VBA Named Range ? (xl2000 sr1)
Calculating on dates (O2K)
Circular Reference Level of Hell (xl2000)
Autodave (2000 SR 1)
Move Down in Sheet: Macro (97 SR2)
Lotus to Excel (2000)
Remove "bad" name (Excel 97 (SR2) Windows)
Get worbook general properties (xl 97)
Limited protection (97-SR2)
AutoFilters don't work when Sheet is Protected (Excel 97)
converting columns to rows (MSoffice 2000)
Excel 97>2000 (Excel 2000)