On my worksheet I have all my staff hours in detail on the left side....the
right side has the basics i.e. start and finish times...
Is there a way to lock the cells on the right from having anything enterred
on them.

I have an application in which I want to have a disclaimer appear that
someone can scroll through. Under that I would have a button that says "if
you click on this button you agree to the above Disclaimer".
I have checked out several forms - The list box and combo box allow me to

I am having a bit of a problem using Arrays and Booleans that I was
hoping someone could shed some light on. I have a table with mulitple
and repeating descriptors that other formulas that gives me a specific
number in certain months.  For example. In row 1 will have a code

I have an inputbox for entering info when the code is run.
However, the user needs to enter a value that is displayed on the worksheet
the inputbox is run from.
But the inputbox positions itself exactly over the values that are displayed

I have several worksheets in my workbook and need to input information
into a worksheet based on the date entered by the user.  the worksheets
are name 01-Dec-06 up too 31-Dec-06 in order. The user in most cases
will enter the information in order meaning after they enter the

I have a some code that uses GetOpenFilename to create an array of
filenames.  Then one by one, the file is opened and a range is copied
to the orginal master file.  After the copy procedure, the file is
closed and the next one is opened.  This procedure seems to work ok but

Hi Friends,
I have the following table of pin names as shown below. 1,2,3,4,5 are
the header rows and A,B,C,D... are header columns.
X/Y     1        2     3    4       5

I have a client that has developed an excel application (single file)
that they would like to protect as much as possible.  What are the best
ways to prevent the code within from being copied?
Is there a way to 'install' an excel document so it can't be simply

I'm not so familiar with Excel macro programming (as is perhaps evident
by my question).
Is there a way to determine which Excel files have macros?
The reason for this request is that our firewall/antivirus appears to

Dear contributors,
I apologise if there is a more appropriate group for this query - I can
see relatively few Notes related posts in the VB/VBA groups and
vice-versa.

Is it possible to do the following:
I would like to create a macro that does one of the following two
things.
1. the macro would have a pick box to select between 12 months of the

Excel XP, Win XP
I have 14 rows of data I want to chart, each row in a different chart.
The following code charts row 1 as the "X" axis and the values in row 2 as
the "Y" axis.  Good.

I have an excel file which runs some vbe via the DocumentOpened event
handler. This code involves the proessing of data, the results of which
are plotted within the excel doc. Finally, the event handler saves the
doc so that when you close it, you are not propted to save the file.

To all,
I have a set of data in two columns A: A, and B:B( Sheet name DATA ).
The A column contains times, and the B column contains temperatures:
i.e:

To all,
I have a workbook with a series of charts, each on their own worksheet.
Is there any way to easily just print all of the charts with the click
of a button using a Macro?