What is the parent of ActiveWindow?
It's not available as ThisWorkbook.ActiveWindow or
Application.ActiveWindow .
Thanks.

I'm using Excel 2000 and creating some user forms.
The form has a phone number textbox that I have added code to vailidate the
phone and put it in a certian format (xxx)xxx-xxxx)
I have set textbox on Enter event to write  "(" before the user start typnig

I have searched previous posts and found how to pass a value from a
module to a form or a value from a form to a module.  My problem is a
little different.  I want to pass a value within a userform from a
textbox to a command button.

When I copy page 2 of my spreadsheet I get an Invalid page fault message,
theeee other pages copy OK.
The page contains bank account for three years so I dont fancy re entrering
it.

I am in need of some help.
I have to get a sheet made that will auto color a row green based on a time
frame.
Example:

How can I restrict user data entry in a column to a certain date format?
MM/DD/YYYY
any help much appreciated! thanks

I have my VBAproject protected from viewing my code.  I want to write a
macro that will unprotect it so I can delete some other modules.  I have
tried:
sub unprotectproject()

I have a macro I use for a spreadsheet and every time I open the workbook,
it gives the warning about it being disabled because my security is too
high. I want to keep my security high, for macros I use that I did not
write. So how can I set it up to avoid that? How can I "sign" ...

I am trying to run a macro at every solver iteration through showref.
However, the solver goes through only the first iteration and does not
optimize the target cell updated by the macro called through showref.
I found an old thread from a couple of years ago on the same issue.

I need to pull the most commonly used word out of a data range. In
essence if I have a list of names; Is there any way Excel can pull up
the name that is repeated the most, and how many times it is repeated?
Essentially a mode of text.

I've created a addin which loads up a skeleton menu which (obv.) can
be used with any workbook. This works fine.
On a particular workbook, each sheet loads (and unloads) its own menu
on the Worksheet_Activate and _Deactivate methods. This works fine

I just would like to get multiple cells from all the worksheets and have them
placed in one summary worksheet but this code stops at pdp = ("N50")????
Sub GetCellFromWrksheets()
Dim wsNew As Worksheet, wsTemp As Worksheet

can anybody tell me how to add a new entry into the main menue bar from
inside a macro? I tried to use the macro recorder, but it seems that this
kind of operation can not be recorded.
Marcel

When the user is selecting a file to open, I want to deactivate the X (Close
Button)  so the user can not exit out of the macro.
Do you know if this can be done?
With Application.FileDialog(msoFileDialogFilePicker)

I am trying to create a hashtable with key value pairs - where both key and
value are strings. How to do this using VBA?
Thanks for any help!