Some sort of pop-up

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have Excel 2002 and a sneaking suspiscion that I have been dooped. Upon
opening a new workbook and typing in any cell on the sheet, a message
automatically appears when I finish the word and hit the space bar. The
message is a personal joke from a friend, but I don't know how to remove it.
I don't want him to get the enjoyment of me asking him how to remove it, so
is there anyone familiar with this kind of thing?
 
Try right clicking on your tab, select view code and see if there is an event
handler similar to:

Private Sub Worksheet_Change(ByVal Target As Range)
MsgBox "Some message"
End Sub


If it pops up on every worksheet, hit Alt-F11 (while in XL-this will bring
up the VBA editor), locate the Project Explorer (View/Project Explorer if it
is not currently visible), locate your workbook and expand the Microsoft
Excel Objects folder, double click on ThisWorkbook (at the bottom) and see if
there is an event handler here similar to:

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
MsgBox "Some message"
End Sub

When you find it, delete the code.
 
I tried to find something like that but when I double click ThisWorkbook,
there is nothing in the window at all. I have the option of scrolling from
the default (General) to Workbook, which changes the other scroll from
(Declarations) to a long list of other options, of which Open is the default.
It then will show a line of code like the one you used as an example but
with nothing in between. Any other ideas on what to do or what I didn't do
right?
 
hi,
who installed this on your pc. Check for a hidden file. when xl opens click
window>unhide.... a dialog box may pop up. click on any file name that may
be there. the virus may be there.

Regards
FSt1
 
Someone in my family who has a rivalry with me. Actually, messing with it a
little more, I found that when I type my name and that only; this message or
phrase appears in its place as part of the line of text I am typing. Its
like my name = "message", so everytime I type in my name, I get this phrase.
Any suggestions?
 
It's an AutoCorrect entry. To remove it:

Choose Tools>AutoCorrect Options
Type the first few letters of your name, and the list will automatically
scroll down.
Click on your name to select it
Click Delete, then click OK
 
Back
Top