Need help - Macros/Code crashing Excel

[Jakobi]

Hello,

I have some basic macros in a workbook. The code do not crash my excel, but when others open it up, it crashes and I am not sure why. Am I missing something?

I have a checkbox, command button, and a combo box.

--------------------
=EMBED("Forms.ComboBox.1","")

-------------------
Private Sub CheckBox1_Click()

If CheckBox1 = False Then
Rows("27:38").Hidden = True
Else
Rows("27:28").Hidden = False
Rows("30:33").Hidden = False
Rows("36:38").Hidden = False
End If
End Sub
Private Sub CommandButton1_Click()

Sheets("Item Image").Select
End Sub
-------------------
-------------------
Private Sub CheckBox2_Click()

If CheckBox2 = False Then
Rows("11:19").Hidden = True
Else
Rows("11:19").Hidden = False
End If
End Sub

Private Sub ComboBox13_Change()

End Sub
-------------------

 

[Jakobi]

Bump.

 

[Hermanito]

I don't see any immediate issues in the code other than you are relying on some default properties. But normally that would not be an issue.

This checkbox, button and combobox, are those directly on a worksheet, or are they on a userform?

 

[Jakobi]

I don't see any immediate issues in the code other than you are relying on some default properties. But normally that would not be an issue.

This checkbox, button and combobox, are those directly on a worksheet, or are they on a userform?

Hello and thank you for your insight. They are directly on the spreadsheet.

 

[Hermanito]

Which Excel version do you use? And these others, do they use the same version?

 

[Jakobi]

I have 2 people try it with Excel 2007 and this is what happens. They can open it, fill out all the data...save it to their computer. Then when they reopen the spreadsheet it then crashes every time.

 

[Jakobi]

Hello,

I have some basic macros in a workbook. The code do not crash my excel, but when others open it up, it crashes and I am not sure why. Am I missing something?

I have a checkbox, command button, and a combo box.

--------------------
=EMBED("Forms.ComboBox.1","")

-------------------
Private Sub CheckBox1_Click()

If CheckBox1 = False Then
Rows("27:38").Hidden = True
Else
Rows("27:28").Hidden = False
Rows("30:33").Hidden = False
Rows("36:38").Hidden = False
End If
End Sub
Private Sub CommandButton1_Click()

Sheets("Item Image").Select
End Sub
-------------------
-------------------
Private Sub CheckBox2_Click()

If CheckBox2 = False Then
Rows("11:19").Hidden = True
Else
Rows("11:19").Hidden = False
End If
End Sub

Private Sub ComboBox13_Change()

End Sub
-------------------

Cross Post
http://www.excelforum.com/excel-programming/787507-simple-macros-crashing-excel.html#post2577566

 

[GRCArizona]

I had a similar issue with some files at work. Finally figured it out: Not everyone was on the same Service Pack. I was on SP3 and several were on SP2. Once they installed the latest SP, no more crashes.

Go to 'Help' / 'About Microsoft Office Excel' Top line indicates which Service Pack is installed.

GRC