I know its possible to change the font size ibn Excel from Control Panel
Display etc etc.  What i's like to be able to do is change the font of the
Added Menu Item i have
EG

I have a problem where I want to run a macro on all rows selected by the
user. The problem lies in, that the macro when ran can create x amount
of new rows below the current one, based on a number entered by the user.
So what I want to do, is after compleating one row, deselect ...

I have a template which uses formulas to drag data from an input sheet
through to a worksheet which manipulates the data. The number of rows of data
on the input sheet is variable.  I cannot use activerange because I do not
want to select cells containing formulas which have not ...

Hi, I just wanted to automatically say no to a msgbox asking if I want to
update the links in  a workbook opened by a macro.
I cannot Select Edit-->Link, because the workbook opened is changed by
someone I don't know and my macro have just to treat his/her file.

User1 User2
----------------------------------------
Table1   Create         1         1
Table1   Alter            1

   I am trying to write a macro to help me sort out some data for
some reports I am running,( I have not really used macro's before and
so don't really know where to start.
Below is a small example of what I am starting with, This covers a

I have a list A1 - J1500.  Column J is dealer name.  B is inventory
item, C is description, D is quantity). I need to copy all dealer A
entries (in sheet 1 only column B,C and D) to sheet 2. Dealer B to
sheet 3 etc.

just a quick one, I am trying to count stuff within a month, This If
statement counts if it is an April date:
If r1.Value > "1/4/2007" And r1.Value < "31/04/2007" Then
           counter = counter + 1

activeworkbook - setting the ReadOnlyRecommended property for the
workbook to True isn't sufficient for my requirements. Would I have to
drive Explorer to set the property or is there a way of setting the

I have the following SQL for 25-04-07 but I want to change it for
today means that if I open it tomorroe then it will show records for
26-04-07 not 25-04-07.
My SQL is :

How do I resize the default grid in a user form in Excel?
I find controls snap to the grid and label and textboxes do not line up
properly.
Also, I have created about 50 text boxes .  I have set the font to size 7 /

I don't know if this is reallya  difficult question, but its got me stumped.
What I am trying to achieve is to calculate a monthly average for individual
users. There is a table that looks like this:
User       23/04/2007      24/04/2007

I use Ron de Bruin's Sub Mail_small_Text_Outlook() (in Office2003) and it
works fine, except that e-mails sent with it are not recorded in Outlook2003
Sent messages. Is there any way to achieve this?
Thanks,

I am using Excel '03.  I am creating a daily activity log.  I would like to
put a button in each cell that will add 1 to the value in the cell each time
it is clicked.  I do not want to have the buttons print on my sheet

Need some help,
Here is what i'm trying to do
I'm calculating the YTD Operational variance for about 1,200 rows (Prior
year and Budget). Icould do this easily on the worksheet but it would take up