Thread: macro warning
View Single Post
  #10   Report Post  
Ken Wright
 
Posts: n/a
Default

If it was on every sheet then chances are that during the design stage
somebody was looking at the original sheet in the VBE before all the other
sheets were copied from that one. Just clicking on the dropdown arrow in
the VBE would generate that code, albeit by itself it does absolutely
nothing. Copying the sheet would then also copy the code etc etc.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"gls858" wrote in message
...
Nick Hodge wrote:
Nothing is put there by MS. It requires the steps you took and then
dropping down the top left dropdown and selecting the 'object'

(Worksheet,
etc). This then puts the default event code template in ready to enter

your
code. That's what you have. On it's own that code does nothing.

(Except
fire the security warning!)

Can't imagine who would have done it. My end users wouldn't
have a clue. The weird thing is that it was on every sheet.
No matter, got it fixed now.

Thanks,

gls858