Can I have the same variable names in multiple different "forms"
inside my personal.xls?   In other words in form1 I have a variable
called SaveToDesktop adn in form2 I also have a variable called
SaveToDesktop.

I need to open a workbook with VBA and disable the macros.  How would I do
this?
Workbooks.Open("C:\Documents and Settings\Me\Desktop\New
Workbooks\MywkBook.xls")

Hi.  I have the following code, but it doesn't seem to work.  I get
the dialog box for Save As, but it is not bringing in the default
directory I have specified.  Any idea what I am doing wrong?  Thanks!
Sub test()

I have drawn a calender on my excel spreadsheet using activeX.
I have a sheet for each month, what I am trying to achive is draw a calender
on each of the sheets, lets say it is the January sheet that I am looking at.
I only want it to show January on the calender and not be able ...

I am trying to adapt Bob Phillips formula
=SUMPRODUCT((B2:B32)*(MOD(ROW(B2:B32)-ROW(B2),n)+1=m))
I have cells, e5,e6,e7,e8,e9,e10,e11,e12,e13,e14,e15, etc
I want to sum, e5,e9,e13 etc

I have the following list.
08459087671
08459087673
08465228672

I have 2 combo boxes in my 12th sheet.  The problem is I can't get them to
run on the load event of the workbook.  I have to manually go in and run each
sub so the lists generate in them.  How do I get the Wookbook_Open to run
those right away?

I asked this question earlier today, but may have scared people off
with how I worded the question. So, is there anyway to set the
vertical page break ranges after the print area has been established?
I would like set the page break at n51, n91, n131, etc.

Hello.  Given the following code, how can I have the result of the
formulas hardcoded?  I tried simply adding .value at the end of each,
but that did not work!  Thanks!
LastRow = Worksheets("Log").Cells(Cells.Rows.Count, "A").End(xlUp).Row

Hello! Please help!
I have a column with 20 integers, from 1 to 20. Each integer is
associated with a value in a second column.
These integers represent 20 evenly spaced points along a circle.

We use a shared spreadsheet to list projects and due dates. One of the
columns contains the start date, and one contains the due date,and several
columns contain team member names, but nothing automatically alerts anyone to
which projects are at the 50% stage and require a ...

Excel97: in COL A, have say 50 rows 1 to 50.  Again have row 70 to 150
another seiral numbers 1 to 80.
Suppose if cell A25 is clicked, how to use countA to find the last cell in
row 1 to 50.

How do I declare an array where the upper bound is not known?
Thanks

I have received a workbook with macros in it. I trust the sender and the
workbook is signed with a digital signature. However, I receive a security
alert informing me that the macros have been disabled because the signature
is invalid and cannot be trusted because the issue of ...

I have a form with multiple texbox controls.  I want the number of these
controls to change based on the number of worksheets in the workbook.  What I
have currently is a form with 36 textbox controls.  If I only have 30
worksheets, then the last 6 are hidden.  If, however, the ...