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