Hi XL-guru's
First I like to express my admiration for your expertise.
I read the posts in this NG for 5 months on a daily basis and I've learned
so much allready.

I am setting up a template (worksheet) for someone to copy as needed.  
Attached to this template are macros and a userform.  
I am setting up this template to use a userform to enter checking account
transactions and each worksheet will be a check register.

Hello, We have a system that builds reports and allows the user to download
them as excel files amongst other formats.
Today I opened up the report to be greeted by a lot of the numbers set as
text format (bringing up the error flag). Attempting to do =SUM(504:550) just

Can someone suggest me a VB code to be placed in sheet event
BeforeDoubleClick so that any cell I double click in colum A, it calls for
macro 'insert_tow'.
If i get this code, I am done for the day as the program is complete with

I have a vba excel 2003 application that adds a menu to the menu bar with
CommandBarPopup. When a graph object is selected, the menu disappears along
with the 'data' menu, how can I avoid this? 'data' menu is not important, but
the other is

I have managed to get a range marked from active cell to the last row of the
data to colum K.
Need to shift this whole range by one or two rows as required to insert
fresh information.  At least pls suggest how to shift the range by one row,

When I am entering text into a cell, previous entries that began with
the same first letter or two will appear allowing for autocompletion.
This is a great time saving thing, however, I made an error on one of
the cells and now every time I enter the value I wish to have

I get lastrow = ActiveCell.End(xlDown).Row and
BBB = ActiveCell.Address(ROWABSOLUTE:=False, COLUMNABSOLUTE:=False)
Range(BBB :K" & lastrow) does not work.
What should be the code to select a range from active cell to the last  row

How do I programmatically replace formulas in a field with values? I
want to let users download an Excel sheet with the current values, but
without letting them see the formulas.
Regards,

Hello, could some one please help me with the following?
I have two Excel 2003 workbooks.  One workbook is named: Master.xls and
the worksheet is also named: Master.
The other workbook is named: Stock Numbers.xls and the worksheet is also

I am wanting to lock up certain cells that are not being used in a wroksheet
so that those cells cannot be selected and have info entered in them?

I can use the file open dialog to select a file:
Sub WhichOne()
MsgBox (Application.GetOpenFilename)
End Sub

I have this sheet with all the values in one column. Each record is six rows
of column A. Then comes a blank row. Then six more rows for the next record.
Then a blank row. Etc, Etc. for 2218 rows of column A (which is why I need a
macro).

I want a sheet to be hiden when the file is closed.
I have done the code to unhide it should the user require but because of
this I want it hiden again when the file is closed (if it has been unhiden)
Can any one tell me where/how I write this?

I want to modify a UserForm dynamically by adding some number of labels from
my VB/Excel program:
Dim labels() as MSForms.Label