Home |
Search |
Today's Posts |
#8
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Date macro | Excel Discussion (Misc queries) | |||
disable macro warning | Excel Discussion (Misc queries) | |||
Help with macro formula and variable | Excel Worksheet Functions | |||
Macro and If Statement | Excel Discussion (Misc queries) | |||
Macro warning window | Excel Discussion (Misc queries) |