Is there another part of your macro(s) that refer to your file name or path
and file name specifically? Has any of that information changed?

The only thing I can see from what you have posted that may have a conflict
is your sheet reference.

Should " Worksheets("sheet1").Range("K4").Value = False " be "
Worksheets("Sheet1").Range("K4").Value = False " ?


Can you post any of your other code? Specifically the portion of it that
crashes.



Mark Ivey


"pswanie" wrote in message
...
office excell 2003
windows xp

i been working on a .xls sheet with 3 userforms and about 8 usermodules.

to start i got

///////////////////////////////////////////////////////////////////////////////////////////////
Private Sub Workbook_Open()
Sheets("Sheet1").Select
Worksheets("sheet1").Range("K4").Value = False
Worksheets("sheet1").Range("K5").Value = False
Worksheets("sheet1").Range("K6").Value = False
Worksheets("sheet1").Range("K7").Value = False
Worksheets("sheet1").Range("K8").Value = False


With Application
.Calculation = xlCalculationAutomatic
.MaxChange = 0.001
End With

Application.Visible = False



UserForm1.Show

UserForm1.TextBox1.Value = ""
UserForm1.CheckBox1.Value = False
UserForm1.CheckBox2.Value = False
UserForm1.CheckBox3.Value = False
UserForm1.CheckBox4.Value = False
UserForm1.CheckBox5.Value = False


End Sub
///////////////////////////////////////////////////////////////////////////////////////////////

when i select disable macro's the workbook dont crash but if i enable it
does....


///////////////////////////////////////////////////////////////////////////////////////////////
file/path access error
///////////////////////////////////////////////////////////////////////////////////////////////

and when i go and look at the repair log i get

////////////////////////////////////////////////////////////////////////////////////////////////
Microsoft Office Excel File Repair Log

Errors were detected in file 'C:\files\Jobcard.xls'
The following is a list of repairs:

Lost Visual Basic project.
///////////////////////////////////////////////////////////////////////////////////////////////