On Feb 25, 6:04*am, pswanie wrote:
office excell 2003
windows xp

i been working on a .xlssheet 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 therepairlog i get

///////////////////////////////////////////////////////////////////////////*/////////////////////
Microsoft Office Excel FileRepairLog

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

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

Maybe you should try a popular Excel file recovery tool called
Advanced Excel Repair to repair your Excel file. It is a powerful tool
to repair corrupt or damaged Excel files.

Detailed information about Advanced Excel Repair can be found at
http://www.datanumen.com/aer/

And you can also download a free demo version at http://www.datanumen.com/aer/aer.exe

Hope this will help.

Alan