I have a couple userforms (created in Office 2007) which use the Calendar
control. When I transitioned to Windows Vista (32 bit version) the Calendar
controls no longer work. I copied mscal.ocx into C:\windows\system32 and
registered it. It shows up when I right click on the ...

i was wondering if its possible to select a cell on a sheet where to
put a combobox or a chart rather than by pixel.
i am planning on making one sheet called graphs which will have 25
graphs each with their own combobox. when you select an item from the

Excel XP & Win XP
This is a minor problem.  I create a menu when the file opens using John
Walkenbach's menu maker code.  It all works fine.
But I notice that the first menu item in the menu has a line under it.

Say, I have the following 9 data points:
1    2    3    4    5    6    7    8    9
15.53    19.99    20.43    21.18    25.93    30.00    30.00    34.01    36.47
Using "Forecast" excel function, I get 38.76

In the same workbook I have two worksheets:
Worksheet 1 Range("D5:D55") is the range to sort Worksheet 2
Range("B4:C103").
Worksheet 1 - data

I want to place a chart and a series of spinners on a userform (I know how
to do the spinners with texboxes for output) ... The chart is driven by the
spinners that send data to the Excel Sheet and the sheet output (algorithms)
drives the chart...

At the top of my module, I have
Private Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As
Long)
I want to Dim some variables that will be used by several subs in this

When I try to break a value into 3 equal parts
ActiveCell.Offset(-1, 0).Range("A1").Select
   ActiveCell.FormulaR1C1 = "=R[1]C/3"
   ActiveCell.Offset(-1, 0).Range("A1").Select

the following code should sort by color.  However, if the spreadsheet is
large the macro runs a very long time.  Will someone write some code that's
more efficient for large spreadsheets, say over 10K lines?
Thank you.

I have a graph that is graphing from a dynamic range and wanted the
max limit to change with the size of the range
is that possible?
it seems like i cannot link it either to a cell or to a name range and

1. activewindow.selectedsheets.visible = false
I know this will hide an active worksheet.
What I would like to know is how to hide the worksheet upon opening the
workbook.

Is there anyway to find the name of the sheet which contains an active chart
using VBA (Excel)?
I want to be able to select the plot and run a macro which set the scales
... resizes the plot area and then the chart area . I can do everything I

I tried the if block to make sure there is a pagebreak in x.  There is a
pagebreak in x because I saw it in the immediate window so the problem isn't
that there isn't any pagebreaks although it is a nice error check for that.
Sub VOD_11x17_Page_Setup()

I am trying to define a variable with the data in the last cell in a column.
I've been trying to use the following:
Range("A1").Select
   Dim DataCheck2 As Date

I created custom toolbars in 2003 and attached them to workbooks. Now that
I've upgraded to 2007, when I open those workbooks in 2007, I don't see the
toolbars. Can someone please tell me where they are? Thank you.