Devious multiplying Forms DropDowns
Hello Darren,
I haven't heard of this. Are you sure it didn't occur when you were
creating them.
Perhaps you created them by copying one and then editing the linked cell on
the copy. When you pasted, it is not hard to repeat the action without
noticing. Perhaps you pasted, edited the link and then inadvertently did
another paste on top.
If I was going to add a lot of Drop Downs, I think I would do it with code
as the positioning and sizing can be done a lot more accurately.
Post back with some details if you want to see an example.
--
Regards,
Tom Ogilvy
Darren Hill wrote in message
...
I've noticed that, when I have a large number of Forms Drop Downs, fairly
often one or more of them seem to decide to copy themselves over other
drop
downs. When I click on the new copies, I notice that it is changing the
wrong linked cells, and discover it is a copy.
Does anyone know why this happens? Maybe there's a shortcut for copying
these things that I'm inadvertently typing.
Darren
|