A workbook as two sheets: Master and Details. The requirement is that
the data entry in the Details worksheet is not  to be allowed unless
the Master worksheet is protected. To achieve this the following code
was written in the Worksheet_activate event of the Details sheet.

i have a simple spreadsheet of
christopher ward      in cell A1
'''''''''''''''''brian wild   in cell a2
####jane brown    in cell a3

I've used a macro of Steel Monkey on Page Breaks based on cell data and it
gave me the result I wanted. But now I want the page number also to change
depending on the page breaks. At the moment I have a worksheet with many 126
pages and it gives as page number 1 of 126, 2 of 126, ...

I would like to know if there is a way to over ride the old format
limitations of a workbook.
I've saved the old workbook in the xlsx format. That however doesn't seem to
help at all.

I have a request to chart data where I only want to display a marker every n
points, but still see the marker in the Legend.
I can do it by setting the MarkerStyle to a value, then go through every
point in the series and change it's markerstyle to xlNone. However, when

I have 5 remote users, all using workbooks running VB.  I therefore cannot
set them as shared.
Through the day I need access to there progress ( as recorded on the
worksheets) in real time - A bit like big brother  

I am recording a macro to remove the fill from a chart (excel 2008).
There are 12 rwos of bars in the chart and so I want to remove the
fills from each bar one as below (series 1 is left alone); problem is
that the macro does not record it when I remove the fill (set it to no

Please I need help in formating date. I have the following types of dates.
What I have            I want to achieve this.
August 2006           08/01/2006
July 2008                07/01/2008

I was using the following code to create a validation list in column A
in the range specified below.
Sub rProducts()
      Application.Goto

Can Excel calculate date/time difference with data in DB2 timestamp format?  
DB2's timestamp format is yyyy-mm-dd-hh.mm.ss.mmmmmm.  i could probably write
some code but i was hoping not to.

I have an Excel spreadsheet that contains data about images, one row
per image.  I now need to insert the image from which the data came in
the last column.  How best to do that?  I would like the images to be
constrained to the cell but stay proportional.

I have a short code to search column C ina sheet for Numerical values as
below:
Private Sub TextBox1_Change()
If IsNumeric(TextBox1.Value) = False Then TextBox1.Value = ""

I have a userform, with a combobox ,its list values are sheets names of
activeworkbook.it has 4 textboxes(input) ,after inputting data in these
boxes,the values be copied to (combobox1.vaue)w/sheet last row.I am using
line code

Okay, I've created a macro to print "Chart 1" in my worksheet. The code is as
follows:
Sub PrintChart()
   ActiveSheet.ChartObjects("Chart 1").Activate

I have input values in 18 cells C8:T8 these cells return a value
through formulas to the cells Y8:AJ8 is there any way to view these
values at the bottom of the screen in some sort of a window so tha t
they can be seen as the values in C8:T8 are entered. And will scroll