Format/programming issue

**thetallguy0** · 03-20-2008, 12:47 PM

Hey presto, found the answer. You were right, somehow the form macros had disabled the formatting function. I diabled the macros, re-formatted the cells and then turned on the macros again and it worked. Great!

Thanks very much for your help.

As you you are my guru/hero I wondered if you have an idea on another little query please.

I have hyperlinks from one cell to another in the same workbook. In the previous version of excel these worked either on enter or mouseclick. In 200. they work on mouseclick only. Is this a feature of 2003 and I can't change it or do you have an idea please.

Thanks very much.

**dominicb** · 03-20-2008, 12:55 PM

Hi thetallguy0

Originally Posted by thetallguy0

You were right, somehow the form macros had disabled the formatting function.

See. Always humour the loony, 'cos you never know when he just might be right. And always try the obvious

As for your other query, I've never actually used hyperlinks much, but as far as I'm aware they are only activated on a click. I've never noticed XL2000 allows the use of the enter key as well. Let me have a try on my XL2K machine later and I'll post back.

DominicB

**thetallguy0** · 03-20-2008, 02:47 PM

Thanks, much appreciated. I might not be able to get to the computer to reply over Easter though. Have a good break. Ta.

**dominicb** · 03-20-2008, 03:00 PM

Hi thetallguy0

Originally Posted by thetallguy0

In the previous version of excel these worked either on enter or mouseclick

Well waddya know. You're absolutely right.
This seems to be one of those little undocumented things that for one reason or another didn't make it throught to Excel 2003.
And another thing. It doesn't pop up again in XL2007, so it looks like it's lost I'm afraid.

Originally Posted by thetallguy0

Have a good break

You too matey.

DominicB