Hi, what I'm looking for is a macro that will save a worksheet as a new
workbook with whatever customer name in a cell in this said worksheet and
then email the new workbook, all by on click. I'm trying to keep this sheet
as dummy proof as possible.

Can someone please give me the formula for a cell to match what the page
header or footer says?
Thanks!

Hi Experts
Small problem for you for me its difficult -- the command button - code below
Private Sub Add1_Click()
Tb99.Value = ActiveSheet.Range("B26")

FSO.MoveFile
With FSO.MoveFile, can you move the files and if they exist write them with
a new name.  If not how can I do that?
Thanks

Can cells or ranges have a LostFocus function behind it?  If not LostFocus is
there something that is compatible with this function for Cells or Ranges?
Thanks
Linda

I have an Excel user defined function (UDF) lets say udf1 implemented in an
XLL.
udf1(X) // Excel UDF defined in an XLL taking 1 argument
This UDF calls a RTD server using the RTD function with 3 arguments

I am looking for a formula that I could add to conditional formatting to
highlight groups of rows EVERY OTHER time the value changes in a column, say
column C.  In my example below if the following values are found in column C,
then the rows containing the 460 values, the 493 ...

Could this be shortened to one block with something like, ("clr1",
"clr2", ..).  Taking it a step further, could the block be replaced
with a single find/replace statement? I'm having trouble getting the
find/replace syntax correct.

I have the following problem.
In a userform i have a textbox with contain a time value.
if i fill in the time value 12:00 and save the time the time i correct given
in the excel sheets.

How do you create a Named Range in Excel 2007?
childofthe1980s

I am trying to create a macro for my personal workbook to use repeately on a
spreadsheet I export from one of my DB's.  The spreadsheet is alway's
formatted the same, but the data table varies in size in the amount of rows.  
I need to compare and flag rows based on a simple array ...

Hi, I wish to save a file which opens with a macro without the "do you wish
to replace this file" prompt appearing.  File is an update of the scheduled
excel spreadsheet from an oracle database.
Thanks and regards,

Hi
I have a number of custom menus that change on diferent worksheets within
the one workbook. How can I ensure that my custom menus always appears
instead of needing to go to "Add-Ins" each time a different worksheet is

This code fails if a graph on the same sheet is selected (clicking inside the
graph)
   Columns("B:B").Select
If I unselect the graph (clicking ouside the graph) then code runs fine.

I am writing a macro that needs to open another file that is password
protected in "Read Only", copy a sheet into my current file and close the
file I am copying from. How do I write the string to select "Read Only" from
the password window?