Need help - Macros/Code crashing Excel

J

Jakobi

New Member
Joined
Oct 26, 2006
Messages
10
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
-------------------
 

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.
Sort by date Sort by votes
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?
 
Upvote 0
Hermanito said:
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?
Click to expand...

Hello and thank you for your insight. They are directly on the spreadsheet.
 
Upvote 0
Which Excel version do you use? And these others, do they use the same version?
 
Upvote 0
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.
 
Upvote 0
Jakobi said:
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
-------------------
Click to expand...

Cross Post
http://www.excelforum.com/excel-programming/787507-simple-macros-crashing-excel.html#post2577566
 
Upvote 0
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
 
Upvote 0
You must log in or register to reply here.

Similar threads

O
  • Solved
ActiveX checkbox that changes color
2
Replies
15
Views
479
John_w
J
A
  • Question
VBA - Hide range of rows IF
Replies
3
Views
157
Osvaldo Palmeiro
O
B
  • Solved
Another VBA question to hide/unhide rows based on cell value in another sheet
2
Replies
12
Views
664
kevin9999
K
B
  • Solved
How to assign macro to cells in Excel
Replies
9
Views
441
Bram1212
B
B
  • Locked
  • Question
Multiply VBA Macro for hiding and unhiding rows
Replies
4
Views
424
RoryA
RoryA

Forum statistics

Threads
1,216,489
Messages
6,130,960
Members
449,608
Latest member
jacobmudombe

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top