I have created a workbook to summarize data from other workbooks.  In order
to accomplish this task, I linked data using formulas.  I am trying to create
a macro that updates the links.  Here's the catch, all of the other
workbooks that are linked have open passwords.  So when I ...

Excel XP & Win XP
I'm trying to learn how to make a group of checkboxes in a UserForm mutually
exclusive (can check only one).
Looking in Help, it says to assign the same group name, in Properties, to

A team here wanted some formatting, dependent upon 4 other cells, in an OR
formula.
if =or(f33<f39,f34<f40) is true, they want cell f1 to have a red background.
If it's false, it has the default blue background.

How do I protect a sheet so that a user can still hide, un-hide, or add lines
?????  Protecting cells, contents, and objects in the usual way does not
allow the user to do so.
If not, is there a way to DISABLE the user's ability to re-format cells,

I am trying to create a sub that prompts a user for an input, in this case a
number from 1-5, and then takes this value and enters it into the Excel
filter tool.  I’m trying to get all the records that are listed on each line
to be copied/pasted to a sheet called “Results”.  I ...

I'm trying to store zip codes in a spreadsheet but am getting issues
with items that start with a 0.
The code I am using is:
<B>Cells(1,15) = "06555"</B>

We have a sheet that contains a good portion of the code as an .xla situated
on a shared LAN drive. The .xla is linked as a reference to a client sheet
that users use (to allow for updates to code without redistribution of
sheets). Well recently we lost connection to the LAN and ...

I have an application that creates a command bar combobox in Excel with about
4800 items.  I have been running this application for years without a problem
under Excel 2000 or 2003.  When running it in 2007 the ComboBox will not
display more than 1000 items.  Running a debug ...

Any idead how to solve  Exception from HRESULT: 0x800A03EC

Excel crash when exiting the application with the Workbook open, if I close
the workbook before exiting the application there is no error.
I found that Excel is running the event Change of a ComboBox of a Worksheet
everytime I close, even if I didn't make any modification in any ...

I need help with code to print single cells??  We have a spreadsheet
with bar codes and need to print them on labels with one bar code per
label.
Thanks

On my worksheet, are 3 hidden columns.  One of the columns contains an ID
Number (for a cost center).  Originally the columns were hidden because there
would only be 1 ID.  Now, the data has been expanded to include multiple IDs.
But I still need to have the columns hidden.

I have tried to use the code:
Private Sub Worksheet_Change(ByVal Target As Range)
Rows("6:18").EntireRow.Hidden = False
Rows("20:37").EntireRow.Hidden = False

I am trying to see if a defined name's RefersTo property contains a
particular string.
To be more specific, I am going through the defined names in the workbook
and checking if any of them are pointing to a particular file path or a

I have series of 6 macros I call with a master macro. I'd like all macros to
run. If 1 or more macros errors out, I'd like it to move to the next macro in
the sequence, then notify me at the end (with a msgbox) which macros errored
out. Here's the basic construct. Thx.