Hiding Promt

[arnoldmo]

Hope you can help - I am new to excel & vb. I desperatly need help. My spread sheet shows a prompt as you enter from the front page page - I use the below to show it.

Private Sub Worksheet_Activate()
EntryWarning.Show
End Sub
Then it unloads when a button is clicked - using the below code.

Private Sub CommandButton1_Click()
Unload Me
End Sub

Once you are in the spread sheet, (sheet 31) some data is recorded on another page (sheet 30). When this recorded data on sheet 30 is pulled back to sheet 31, the warning message shows again. How can I only make it show at the 1st entry & not when it is pulling data from sheet 30. The coding I use is below to pull the data from sheet 30 is below.

Private Sub CommandButton5_Click()
Sheet30.Activate
Sheet30.Range("A1:F10").Select
Selection.Copy
Sheet31.Activate
Sheet31.Range("E20").Select
MsgBox "You must now paste this information into a new heading"
Application.ScreenUpdating = True
End Sub

Hope you can help

xxxx

 

[sadath]

don't activate sheet30 instead from sheet31 you can copy contents of sheet30
like

Private Sub CommandButton5_Click()
Sheet30.Range("A1:F10").copy
Range("E20").Select
MsgBox "You must now paste this information into a new heading"
Application.ScreenUpdating = True
End Sub

 

[arnoldmo]

Thanks you very much - this works a treat.

x x