Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Some sort of pop-up
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Some sort of pop-up
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. "Jay Carroll" wrote: 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Some sort of pop-up
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? "JMB" wrote: 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. "Jay Carroll" wrote: 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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Some sort of pop-up
hi,
who installed this on your pc. Check for a hidden file. when xl opens click windowunhide.... a dialog box may pop up. click on any file name that may be there. the virus may be there. Regards FSt1 "Jay Carroll" wrote: 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? "JMB" wrote: 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. "Jay Carroll" wrote: 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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Some sort of pop-up
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? "FSt1" wrote: hi, who installed this on your pc. Check for a hidden file. when xl opens click windowunhide.... a dialog box may pop up. click on any file name that may be there. the virus may be there. Regards FSt1 "Jay Carroll" wrote: 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? "JMB" wrote: 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. "Jay Carroll" wrote: 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? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Some sort of pop-up
It's an AutoCorrect entry. To remove it:
Choose ToolsAutoCorrect 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 Jay Carroll wrote: 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? "FSt1" wrote: hi, who installed this on your pc. Check for a hidden file. when xl opens click windowunhide.... a dialog box may pop up. click on any file name that may be there. the virus may be there. Regards FSt1 "Jay Carroll" wrote: 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? "JMB" wrote: 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. "Jay Carroll" wrote: 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? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Ascending Sort formula, change to neg #: descending sort.. | Excel Discussion (Misc queries) | |||
data sort is not including all columns in sort | Excel Discussion (Misc queries) | |||
Excel sort by Fill Color by custom list sort | Excel Discussion (Misc queries) | |||
Excel Sort function should not sort the cell formatting! | Excel Worksheet Functions | |||
how can I hide sort ascending and sort descending options in the . | Excel Discussion (Misc queries) |