The following piece of code works fine:
CommandBars("Worksheet Menu Bar").Controls("File").Controls("Save
&As...").Enabled = False
However, if I change it to try and disable the Hyperlink menu item, it

BUY CHEAP SUPER VIAGRA ONLINE AND SAVE 7
% OF MONEY...
BUY LOW-COST VIAGR
ONLINE

A cell in the sheet 'PARAMETES' contains 'Communications!F:F'
I have named this range 'Division'
When i use the code below in the PARAMETERS sheet:
=COUNTIF(Communications!F:F;D2)

Looking to create a macro that will erase all columns except where the
first cell (row a) contains the name:
Eggs
Cheese

I need to create a pause in my Macro to give the workbook time recalculate.

Following is my code, basically this report is run weekly from previous
Monday date to Sunday date.  This macro does everything except add in those
dates to the file name.  Any suggestions?
Dim wb As Workbook

I have this code that runs very fast the first time I open the workbook and
run it.  All subsequent runs are about 1/2 to 1/3 the speed.  I don't
understand why the slow down.  Can someone explain it to me?
Would I be better off taking the hide/unhide rows portion of it and making ...

have sheet with 7 columns of numbers. need to format so numbers 1 thru 9
have a 0 put in front. 01, 02, 03.....
any help?

my spreadsheet is:
invoice_no                     product
=======                      ======
inv/1                             orange

I am trying to find the best way to refer to cells in a large range
based on the column they are under. The number and order of columns in
the range is changed frequently and I want to make sure that the
reference always works, so I can't simply hard-code a column number.

I have calculated a variable 'n' in a macro and want to put it into a
spreadsheet.
The expression ActiveCell.Formula = "= Max(R3Cn:R3C256)" doesn't work,
although substituting a number for n does work

Excel 2003
On my PC I am the only user and Administrator.
I'm trying to apply a digital signature I have created to an Excel file
containing macros.

Excel XP & Win XP
I'm trying to write one line of a Select Case construct that encompasses
either one of 2 values.  Something like:
Case 34 Or 116: Call DoThis

I new to VB programming.  I need to create a macro that will be able
to copy the sheet and then format the copy to look like the initial
sheet.  Here is my copy:
Sub WorksheetCopy()

Imports Microsoft.Office.Interop.Excel
Public Class TransferTool
Private Sub btn_PrevData_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles btn_PrevData.Click