Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I don't know why but this macro wants to exit excel when I run it
Sub resetpage() Range("A3:S20").Select Selection.ClearContents Range("A3").Select userform1.Hide End Sub I have userform1.hide because I have a worksheetchange event that goes like this: Private Sub Worksheet_Change(ByVal Target As Range) Application.ScreenUpdating = False If Target.Column = 1 Then userform1.Show False myRow = Target.Row End If End Sub When I run Sub resetpage() it clears the contents and then asks if I want to save changes as if I had clicked exit Why is this now happening? it doesn't happen all the time ,but it happens alot |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Importing Outlook Alias into an Excel 2003 macro | Excel Discussion (Misc queries) | |||
Excel macro | Excel Discussion (Misc queries) | |||
Closing File Error | Excel Discussion (Misc queries) | |||
Relative Ranges in excel macro | Excel Worksheet Functions | |||
Macro in Excel 2002 to save a workbook to a FTP location | Excel Discussion (Misc queries) |