I have date in "A1" = 28/02/2008
I want to save worksheet as:
"c:\ToCav0208m.csv"

I am distributing an excel spreadsheet which includes cartographic functions
written in VB.  They are starting to be used
in critical operations like search and rescue so I want to hide & password
protect the VB to prevent code changes, just as

I would like to change . to / of date fields in column M. If I try to find
and replace individually all works Ok but if I use replace all it seem to
change the date. For example when I use replace all for 08.03.2008 it ends up
as 03/08/2008 but 18.03.2008 changes OK to 18/03/2008 ...

the excel file im working on performs code too slow. it tak emore than
30min to upload and update everything. is there anything i can do to
make it perform a little faster
heres the code im using:

How would I rename the tab with a Text Box on a worksheet?  Not a
userform
I've tried the following doesn't seem to work.  
Private Sub TextBox127_LostFocus()

I have some code that automatically fills in 6 pages of spreadsheet
from a form, it then prints the entire spreadsheet and saves it as the
repair order number into a file called new repairs.  This has been
created with a lot of trial and error, but i got there.

For example, I have a excel sheet with two columns, A and B.
B's value is calculated based on A, e.g. =A1+1
My problem is that the formula is only applied to the cells selected.
I have to drag it to apply for other cells.

How do ya shift L or R several lines of code once you've highlighted
it?
Thanks.
***

First timer here :).  This issue has been drving me up the wall and
after traweling the Internet I am no wiser.
I want to execute some code when the user clicks on a combo box,
before they make a selection.  E.g.  "Do you want to save changes? Yes/

Using Excel 2000.  The below lines are on two rows, I'd like to have as a
few more rows so it's easier to read albeit the  _ (space underscore)
doesn't like breaking the lines.  Is this possible?
Also, I don't really like the [65000] in the code but I don't know any other

Hi,
I need a one time solution to this problem, does'nt have to be elegant or
repeatable!:
I need to be able to change the sheet part of the chart source property

I have seven combo boxes on a worksheet. After the code has run to add an
entry to the list I would like the next combo box to take the focus  and so
on, preferably with a differentbackground colour if possible.
Thanks in advance

Private Sub CommandButton1_Click()
NewRowCount = 1
Lastrow = Range("N" & Rows.Count).End(xlUp).Row
For RowCount = 1 To Lastrow

I have written this code which works fine but i would like to know if it is
possible in some way to have the code execute but not lose the combo box
while the code darts back and forth across the sheet.
Private Sub ComboBox5_LostFocus()

I have 100 spreadsheets. I defined a range 'MyRange' (insert>Name>define) in
each one of them. 'MyRange' in all the spreadsheets starts in cell A13 and
ends somewhere in column D. so in Spreadsheet 1 it could be A13:D30, in
spreadsheet 2 it could be A13:D50, etc.