Hi there,

BACKGROUND - A while back, I was trying to change my "Comma Style" button to
format cell(s) in the #,##0 format rather than the built-in #,##0.00_)
format. I was trying to change this button via a Macro in my Book.xltm file,
so when Excel opened, the button would act as I want.

As a test to see if I was putting the Macro in the correct place and to see
if it was working when I opened Excel, I put a Msgbox in the code to give me
the "Hi" message. It didn't end up working correctly and I left it alone.
There was a Comma button on my Add-Ins menu, and it would display the "Hi"
message when pushed, but the cell format wouldn't change. I have since
right-clicked on that Comma button and deleted it. (I have also gotten the
comma thing to work the way I want, so I don't need help with that.)

CURRENT - I wrote some code last week and was testing it before sending the
spreadsheet out for my contact to work on it. When I push a button that I
have entered on the spreadsheet (HOME tab), I want to record the user's
entered data on a second tab (HOME2). If HOME2 is not hidden, the code works
as intended. However, when I hide HOME2, my code doesn't run past the
Worksheets("HOME2").Select
line, but, instead, I get the "Hi" message from that old code I had. I have
realized that I need to change that line to
With Worksheets("Home2").

My problem is that I cannot find that old code ANYwhere to be able to delete
it. I had my co-worker test the spreadsheet on his computer and he also got
the "Hi" message, which means when I e-mail it to my contact for user input,
they will get the message also. Obviously, I can't have that. Can anyone
help me find that old code?
--
TIA, Brad E.