Hiding Excecution From User

Alexxx12 · #1 (**permalink**) 09-13-04, 11:24

HI,

win xp
excel 2k

Is there a way to run this code from sheet1 without seeing anything happening? the changes is long. In another word, I don't want the user to see what takes place in sheet1.

Code:

Private Sub CommandButton1_Click()
    sheet2.activate
    Dim FNAME, LNAME As String
    FNAME = InputBox("OLD NAME? :", "Name to change", "THERESA")
    LNAME = InputBox("NEW NAME? :", "Name to change", "PAMELA")
    Dim MyCells As Range
        
        For Each MyCells In Range("A1:BX356")
                'MyCells.Select
                If MyCells = FNAME Then
                MyCells.Value = LNAME
            End If
        Next
sheet1.activate
End Sub

ray705 · #2 (**permalink**) 09-13-04, 15:22

Turn off the screen updating as follows.

Code:

Private Sub CommandButton1_Click()
    sheet2.activate
    Dim FNAME, LNAME As String
    FNAME = InputBox("OLD NAME? :", "Name to change", "THERESA")
    LNAME = InputBox("NEW NAME? :", "Name to change", "PAMELA")
    Dim MyCells As Range
        
Application.ScreenUpdating = False
        For Each MyCells In Range("A1:BX356")
                'MyCells.Select
                If MyCells = FNAME Then
                MyCells.Value = LNAME
            End If
        Next
sheet1.activate
Application.ScreenUpdating = True
End Sub