> Tim-
> I don't know the beginning of this thread, but that
> code is supposed to go into the Sheet Module, by right
> clicking on the sheet tab and choosing view code. It does not
> go into a standard module(module 1 as you called it). Do not
> change the name of the sub.
OK, I put it into a Sheet Module, named it back to
W0rksheet_BeforeLeftClick. Nothing happens.
> And yes, you can call a macro from a
> shape(maybe like something from the drawing toolbar) by right
> clicking on the shape and then assigning your chosen macro to it.
Maybe I'll try that. Can't do any worse.
--
Tim Slattery
[EMAIL PROTECTED]
--
----------------------------------------
To Change your email Address for this list, send the following message:
CHANGE WIN-HOME your_old_address your_new_address
to: [EMAIL PROTECTED]
Note carefully that both old and new addresses are required.
