With code in Module 6, I created a button on a sheet as follows:
   ActiveSheet.Buttons.Add(1245, 16, 80, 16).Select
   Selection.Caption = "AutoFocus On"
   Selection.Name = "AutoFocusBut"

I need someone to give me a few buzz words and point me to some reference
work so that I can get started.
I want to place several buttons on a worksheet that will help the user move
around. I need to create a button then upon activation change the Caption

linked from: http://www.mrexcel.com/forum/showthread.php?t=320701
I was thinking 1 full day yesterday about this....I still couldn't
think a way out of this. I need to convert database sheet to Navision
template as shown below(please refer to the link above for the

Do you know what the math is behind the Linear Trendline which results when
right clicking on a line chart?
Thanks,
John

Hello, I have Excel 2007
I have a series of increasing numbers which have been trucated (rounded
down) to integers , eg
2,  2,  2,  3,  3,  3,  3,  4,  5,  5,  6,  6,  6 etc

I'm sure this is simple for someone:  I have a list of items with counts.  
On the last row for a particular item, I want to add up the counts for each
previous matching line and create a new 'total'.  Some items have only one
row, others have upto 4 with counts in each.  I want ...

I have the following columns: Job Title, Week, Total People
The data looks like this:
Job Title       Week      Total People
PM                W2          1

I have the following columns: Job Title, Week, Total People
The data looks like this:
Job Title       Week      Total People
PM                W2          1

i need to do a weekly schedule for a painting company with a place to put the
work order numbers and hours in each job, i have excel 2003, how do i do
that????

I am really new at this, How would I write the formula - if G2 equals F3
turn H3 red.
Thanks
-

I have at any one time a set of approx 200 workbooks that contain data in the
same format.
I would like to quickly identify the worksheets that contain a date in
either / or both of two cells. Same cells in each workbook.

I'm working on a macro to extract data from a workbook and parse it
out to separate workbooks based on values in column A. I acquired this
from an older post that put the data in separate worksheets. I've been
tweaking it to suit my requirements but it chokes whenever it gets to

I'm trying to enter records into a spreadsheet.  everytime i Try to use a
dash, it converts into a date

.I am just turing to Take a Total (B2) and subtract b4:60 and I get a value
error message.  My formula looks like this =Sum B2 - B4:B60 What I I doing
wrong!!!
Thanks -

Can someone please help with this query,
I'm trying to password protect a macro.
When I use the following it will ask the user for a password and *******
will be displayed in the input box, however when the user types in their