I have an Excel workbook with 20 worksheets in it.  We would like to make the
workbook available on a network drive and restrict access, by user, to
individual worksheets.  Is there a way to place password protection not just
on the workbook itself but on the individual sheets?  ...

In the MS Invoice Template there is instructions when you high-lite some
cells ie "State". How do you create that block?

I have a directory called "model" located at C:\team\model.  Inside C:
\team\model\ is a file called "master.xls" , and the following
folders:
One

Below is a snippet of code that finds the first empty column and pastes
information down the column. I want to select the newly pasted range for
editting. The last line does in fact select the proper range of cells after
pasting, but results in the following error message:

I have added a combobox to a worksheet but it doesn't seem to show up
in the VBA editor in the auto help/fill. I can't even reference it by
typing the name any where in the code. Am I missing something? Thanks
for any help.

Is there a way I can add a custom icon to display when the error alert
pops up in a data validated box? Is there code I'd have to write, or
does Excel reference a folder for those icons and I could add my image
to that folder?

morning all,
I have a sub that searches a list box of values for matching words from a
text box. The problem is I only want to find whole words and it will
currently return results if the letters are part of a word (ie searching for

I need some help creating a UDF that concatenates a RANGE of cells as
follows:-
1. If the cell is BLANK, do not concatenate it
2. If the cell is NOT blank, add a BULLET and SPACE to the start of

I have a spreadsheet with about 100 entry spots
I have macros written to save the data, what I would like is a way to stop
the save if not all the data is entered, and come up with a text box warning
"Not all Data entered"

I assigned a shortcut key to a macro using "ctrl" and a letter.  The
following "sendkeys string:=" does not function properly.  If  I run the
macro without the shortcut key, the macro runs properly.  Is there a remedy
so that the macro may run using the shortcut key?  The macro ...

I'm just wondering if there's some sort of reference somewhere that I
can use to figure out what available script functions there are in
Excel.
I'm interested in making a macro that does the following:

sI have a Combobox whose RowSource is a list of dates for the current and
last year.  When I display the dialog, the Combobox shows the dates as their
values as opposed to January 2007, etc.
Picking up on another thread, I have inserted in the activation code for the

Could anyone help me with the option xlOtherSessionChanges.
I tried whatever options I could think of but could not find a solution.
I initially used the following syntax  
"ActiveWorkbook.ConflictResolution = xlOtherSessionChanges"

To all great minds out there:
A number of people have just started having issues with some macros
that I wrote a while ago which have been working fine up until now.
There is a compile error that keeps coming up. Variable that were not

I have an Excel sheet containing variable length alphanumeric productIDs. The
productIDs always start with digits and may end with hyphen and characters,
eg. "12345-ABC".
When importing the sheet using