Follow Cell pointer

**pieterse** · 2010-04-01 03:29

Hi all,

I devised a small addin that shows two arrows pointing at the current location of the cell pointer.
It has a small toolbar with enable/disable buttons and a button to "lock" the current two arrows.

###EDIT###: New version with two bug fixes.
###EDIT###: New version with bug fixes.

**AndrewKKWalker** · 2010-04-01 09:47

Nice.

Is there a way to change the line width and arrow head size?

I could look through the code, but it is easier to ask.

IGNORE That request, I Just Looked in the code!

Be Nice to Have it on the mini toolbar as a configuration option.

**pieterse** · 2010-04-01 11:56

I thought of that, but hey, if you can find it in the code...

**WebGenii** · 2010-04-01 17:22

Very sweet, now I just need a version with a cluebat!

**AndrewKKWalker** · 2010-04-01 19:24

Had a little tinker with this.
More academic than practical
But now have a tool to change Line width and colour off the Menu
Would like to use a normal colour mixer rather than RGB Numbers, but still working on that.
If it gets to a point where I think it is worth it, I'll post it back.

[attachment=88425:FollowCellConfig.jpg] [attachment=88426:FollowCellDemo.jpg]

**pieterse** · 2010-04-07 08:41

I've updated the add-in with some features (not color though)...

**AndrewKKWalker** · 2010-04-07 14:36

Just looking into this now.

Is it possible to set the arrows so that they do not print.

**AndrewKKWalker** · 2010-04-07 19:14

I have added Colour and Line Style plus more Weights.
However, cannot get Non Printing of line to work.

moPtr objects ought to support the PrintObject=False Property I think.

However IF you remove the On Error Resume Next, it fails
with a Property / Method not found Error.

Not sure why because it can be set for a normal line or arrow.

OOPS I Appear to have posted the WRONG ADD IN File Yesterday (Edited 8th April 11.00 am)

Here is the correct one [attachment=88464:CellPointer.zip]

**pieterse** · 2010-04-08 08:09

Updated with a beforeprint event to make the arrows go away when printing.

**AndrewKKWalker** · 2010-04-08 12:07

That is where I was getting it wrong then.

I was trying to include it in the CLASS Module

SetPointers Sub where the other parameters are set.

**pieterse** · 2010-04-09 07:35

Update which remembers the toolbar position...

**bizon55** · 2012-08-01 00:10

how can I set follow-cell-pointer "dissable" by default?

Thread: Follow Cell pointer

Thread Tools

Posting Permissions

Internet Services

Web Development

Digital Marketing

Consumer Tech