I have a user of Excel 2000 reporting to me that upon opening my Excel file
which has two command buttons (from control toolbox), the buttons do not
appear, i.e. they are invisible.
I created the file in Excel 2002, and tested it with Excel 2000 and even

Good evening:
I´m trying to create a vba function to look for in a double entry table.
The imputs for this function are:
1 the table name in Excel

I have the following code:
dim a as string
a = ActiveCell.name
   MsgBox (a)

In XL 2007, I add a program that adds a custom menu item to the shortcut menu
and it works fine. BUT, two things:
1) A menu item in the ribbon called "Add-Ins" appears. How can I delete or
hide this or otherwise prevent it from appearing?

When you click on a command button, it seem to be selected always and when a
user does not know that and they click the enter button, it runs the macro
again. How do de-select the command button once it's clicked?
Thanks

Im facing a task where I have to generate a datelist with all the dates
going from the previous time the user ran the macro to the present time.
Also, if the macro could delete all the weekenddates it would be a nice
feature as they are not needed here. Does anyone have any ...

I have some Label controls placed on a Worksheet.  I want to update
the captions using the outputs from an optimization model.  However it
looks like the method is different that updating the same control on a
form.  I realize that Worksheet controls are managed in the Shapes

I have a work log I am using in Excel, and have a custom feature that
will sort by status which it gets from the first column.
The cursor postion end up at A1 "top of the page"
Below, is what I have right now and I think the "Range("A1").Select"

I have a workbook that is rather large. It contains a link and a list
of calculations. Instead of having to wait 2-3 minutes for this
workbook to open ( update link and perform the calculations), I'd
rather link this action to a button to be excecuted only after the

I am trying to create a page that would generate a report using my existing
data, however when I try to do it in excel I cannot figure out how to make
the program recreate multible pages(reports) for my data. My report is only
able to show 15 rows of data with all the page ...

Does anyone have a vba code that checks if all the formulas inside a
worksheet does not contain any errors such as #REF, etc ... ?
Thank you in advance !

I launch a fresh instance of Excel, which opens fine. And then it
automatically launches another xls file
(C:\ExistingFolder\PreExistingFile.xls)
How does it do this? Or how would we program this?

I have the same 3 pivot tables on 5 sheets. Each of them references data that
is on their own sheet (with a named range). The sheets were derived by
creating my data and pivot tables with a one-cell parameter and then copying
that to sheets, giving each a new name and changing ...

Hi
I have a table of data with 12 column headings P1 YTD through to
P12 YTD, these refer to the month in the year.   For my current month,
currently P9 YTD, the column has a vlookup to populate the data.  I have a

Hi
I need to write/record a macro to copy and paste special values of certain
columns  depending on the column heading.
I have a table of data with  headings P1 YTD, P2 YTD, etc up to 12.  Some