I use the code below to export a series of sheets to a new workbook.  I need
to know how to NOT export the button objects.  Everything else is fine, but
not the buttons.  Can anyone help me?
Sub Mail_Sheets_Array()

I would like to write a user defined function that, as part of its
execution, needs to know the cell address from which it is currently called.
I.e. if
   cell A1

Hi Gurus
I would really appreciate if I could have a VBA script/ Macro that
will do the following:-
Extract eg 32MPA , 20MPA , 40MPA fro a text string as per below

I have the following code to refresh a query and it works fine until I
install the file on another PC.
Private Sub CommandButton1_Click()
Sheets("Invoice Due").Activate

I was wondering if it was possible to have the result of a formula hide or
unhide rows.
Also, is it possible to use a checkbox in excel where if the box is checked
off then a row is unhidden and if the box remains unchecked a row is hidden?

I am working on an ambitious project for my team to create a vacation
calendar.  I need to be able to lock specific cells based on different
criteria.  Below is a sample of what the sheet will look like:
   A             B           C                  D          E              F

Hi folks, I'm really hoping someone can help me with this question, it has
two parts.
I have a folder called 'MyProgram', and within it I have a folder called
'Data'. In the MyProgram folder I have the currently active workbook,

How can I automatically resize a picture to a cell of preset width &
height?

I am running a macro pressing key F8 but it doesn't show me anything
atall. I put also break points with F9 but it goes directly to the
end.
I changed all the application.run with call, but is still not working

Can someone tell me how to VeryHide and also to make a worksheet visible
again using VBA?
If thats not possible can I just regular hide and unhide a worksheet using
VBA?

I know that it's possible to unselect the controls toolbar listbox by
changing listindex  to -1
but I was wondering if it's possible to unselect the forms toolbar
listbox? It doesn't seem like you can. Thanks, Matt

The following code worked in Excel 97 but not worked in Excel 2003, why why
why???
and how to fix???  Thanks!!!
Sub test()

I'm working in Excel and I have formulas that may need as many as 14-16
functions.  "HELP" says I can use only up to 7 functions.  I know there have
been loger formulas written and used, how do I get around this conundrum?

I have several files with different names. All of them have, one sheet with
the same structure
I need to copy these sheets into a new file, one after the other.
Is there a way to automate this task?

Each day I create a new worksheet which shows the differences for the
prior business day on 4 accounts.  I would like to be able to see the
aggregate differences for the past 30 business days on each account.
To make it simple I post a simplified version of this here.  "Data