View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Trip[_2_] Trip[_2_] is offline
external usenet poster
 
Posts: 6
Default VBA IDE Weirdness....

Hello all,

A little weirdness occurred with my VBA development environment and I was
wondering if it is anything to be concerned about...

I had CommandButton1 on a sheet and a corresponding "Sub
CommandButton1_Click()" routine in VBA. Somehow, the name of the button was
changed to CommandButton2 - not by me, and I'm the only one writing code on
this workbook. Yet the routine's name did not change. Obviously, the
button stopped working. When I went to change it's name back I would
immediately get an error about "Ambiguous Object Name" (or something very
close to that). Ultimately, I had to change the name of the routine.

I scanned the workbook for viruses, and found nothing. Does anyone have any
ideas as to what happened.

Thanks!

Trip