View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Help - Change Event triggered on File Save As

Is it linked to a cell. Try removing the link.

--
Regards,
Tom Ogilvy

Dee Veloper wrote in message
m...
I have a problem with a simple excel 2002 application I am developing.

Whenever I do a "File Save As" the sub below is triggered.
(To help pinpoint the problem I stripped the application
of every single line of code and added this one below and modified the
offending sub as seen below)

Private Sub ComboBoxPC_Change()
MsgBox "hello"
End Sub


The combo, from the control toolbox, is on a worksheet.

Even though the file is devoid of all code and the combo no longer has
any function the "File Save As" will still trigger the Message dialog
shown above.
A simple file save will not trigger the event.

this is really puzzling, to say the least.

any help would be appreciated. this is driving me nuts.