Hi, I've written some code that toggles the contents of a cell from a checked
box to an empty box.  This works great unless the user accidentally clicks on
the edge of the cell.  If the user does this, it jumps to the end of the
range of cells containing the boxes.  I know this ...

A database query program outputs as an Excel 3/4 version file.  When I
open in Excel, make any changes and save the file, I get the dialog
asking if I want to save in the latest version (I have XL 2003 on my
machine).  I'm creating a macro to do most of the changes I normally

Hi everyone.  What I'm trying to accomplish is to have the user click
a button and have the SaveAs box come up with a default folder
location.  The code below does that fine.  But, the file is always
saved as the default name (Book1), even if I change it to something

How do I format an entire row with yellow background if the value in column F
i s larger than 4500?

Fellow Forum Members,
I need to transfer data cell for cell from Excel into an existing table in
Word 2003. The table in Word utilizes  headers. The problem I am encountering
is that the code does not recognize the headers and is not transfering the

I am trying to use 'data > sort' for a range of cells that have different
sized merged cells in each column and I get an error saying that merged
columns need to be the same size.  Is there any other way to sort this?
Thanks

I am looking to build a macro that will do the following from a single
button click in XL 2003:
1) Open a predefined Word document that I am using as a template;
2) Copy a selected chart to a specified cell within a table in the document;

I have this change macro and in o1 I have the cell link for a combo-box.  
When a value is selected in the combo-box the number changes in o1, but it
does not trigger my event macro because I'm not changing the value it's
simply updating from the combo-box.

Hi
I have been using a excell sheet with out any problem for several month, but
suddenly one member in the group can't save the excell file. He get's the
following message:

ok probably a simple problem, but here goes, basically I have a range
of values which I have pulled in from a separate report, however this
is in the wrong format for my colleague to use due to the formulas.
I'm pretty new to macros and have played around to the stage of

I have a shortcut linked to one of my excel files in the XLSTART folder
however when I open Excel it won't open but when I click on the shortcut it
opens the file.
How can I fix this?

Howdy,
I have programmed in Excel in a long time and am not sure where to begin...
I have some data in 5 column such as:
Name, City, X-coord, Y-coord, Item

Hi all, i have some grouped columns on a protected sheet and would like to
know if it is possible to ungroup them ?
Any help would be much appreciated

I ran Acclnk.exe to load the add-ins.  When I click data, the access choices
are not listed.  If I click tools, add-ins the box is checked, I uncheck,
close, open, recheck, click data and the items are listed.  Why do I have to
do that each time?  Am I missing something?