I have set the "Lock project for viewing" in my Project Properties.  Just to
keep away casual prying eyes.  There is a section in on of my modules where
I delete other modules (but not the one where the code is running):
With ActiveWorkbook.VBProject

Can anyone help?
I always get True for ActiveWindow.DisplayOutline regardless if I
really have an outline or not. Has this to do with my Excel being 2002?
I need to determine if the sheet has an outline so as to collapse to

I am an intermediate user of excel, however my knowledge of VBA is a
little rusty.  I am currently stumped on this problem for a worksheet I
working on:
Worksheet is "RateSheet" and already unlocks and locks certain ranges

I wish to use VBE to process all the ducuments currently open in excel.
What kind of object do I associate this code with? For example, a macro
is used to associate vbe with a document and a key shortcut can be
issued to trigger this macro if this doc has focus (is the active

I would like to use this function in one of my application.So I wrote
the following code:
Sub sTestAppQuite()
Application.Display

I have two sets of data where dataset 2 is a subset of dataset 1.  I
would like to copy all rows in dataset1 where the same identifier is in
dataset2 to a new worksheet.
Dataset 1 has 12500 entries and dataset 2 has approx 2500 entries.

Other than the AutoRecover save option under Tool/Options/Save, is
there a way to create a procedure that will save the file every let's
say 30 seconds?
Thanks,

I am new to Excel VBA.  I have a module that works perfectly.  I do the
following steps to run it:
Open Module
Alt_F11

Hello All, I am trying to find a way to utilize the web browser
workbook. What I want to do is take the web browser built in excel vba
and make it erase all history automatically. In other words i want to
create a dream browser for people who like surfing the net privately at

To  all,
I have recorded a macro that imports a csv file into my worksheet.
However the file selected is 'hard coded' into the macro. Is there any
way that I can get this to change depending on which file the user

Just posing a small and potentially simple question (well not to me!)
I have made a tiny excel 'program' that looks at the contents of its
sheet and then returns the answer from it, and through it you can add
new entries to the sheet (sheet1).

How can I reference the size of a spreadsheet (not necessarily the active
one) in an automated way?  Ideally I want a cell in my active file to show
the size (i.e. 50k) and will change each time the active spreadsheet is
opened as the external file grows in size.  Any thoughts?

OK what i have is in column E is the real due date and what i need to do is
if the date is not 9/1/2006 then i need to move the date to column E on the
same line and change the date to the next month 1st day.  I need to do this
as a macro that doesnt have a set number of rows as ...

Referring to Excel General Question
Does anyone know how to perform this kind of sorting in excel?
13, 8, 7, 7, 14, 14, 14, 3, 3, 3, 23, 19, 2, 2
The above values are listed from cell A1 to A14

I have created a macro which allows me to convert some of the
information in my excel file to text file. The problem is that I have
dozens of excel files which I need to apply this macro to in order to
create text files for each of these files. Is there an easy way in