Ivan etc. HEEELLP! (please) (resolved)

[sykes]

Guys
I was working on my latest project, and posted a question about cell comments etc etc.

This was answered by Jak and Ivan.

I was playing around with Ivan's solution (which can be found at :
http://www.mrexcel.com/board/viewtopic.php?topic=20001&forum=2&5)
but now I've suddenly found that I'm having problems with getting code to select cells, and that when a range is selected on a sheet, it remains selected, even if I go to another sheet, and select another range there. I'm not suggesting for one moment that Ivan's code was anything to do with it, I only mention it in order that it may help with diagnosing my problem.

The part of the code I had been playing with was towards the bottom, i.e. changing the font, and comment shape size.
Can't help thinking I've inadvertantly set up excel differently.
I've tried opening another workbook, and shutting down and re-starting, but to no avail.
I'm running windows 98, and excel 2000 premium.

Ta, hoping

Sykes

_________________
....and the meek shall inherit the earth...
(but not the mineral rights!)
This message was edited by sykes on 2002-08-27 02:38

 

[Jack in the UK]

Hi Sykes it Jack

Dant know Ivans code i use a few are spot on, can you email me the code all the sub, or send the sheet, ill have a look tonight and see if i can help.

Let me know what result you want. Just a point Ivans a pal and i d chat to him sometimes as i do others hes now 11 hours in from of us, so its Monday already and he might be asleep, saying that hes awake sometimes very late so thats a reason sometimes guys miss posts, i have been agro by guys not replying they are US guys and so are 8 to 12 hours behind me, thus it goes on, TIME is an issue.

 

[Ivan F Moala]

On 2002-08-25 05:22, sykes wrote:
Guys
I was working on my latest project, and posted a question about cell comments etc etc.

This was answered by Jak and Ivan.

I was playing around with Ivan's solution (which can be found at :
http://www.mrexcel.com/board/viewtopic.php?topic=20001&forum=2&5)
but now I've suddenly found that I'm having problems with getting code to select cells, and that when a range is selected on a sheet, it remains selected, even if I go to another sheet, and select another range there. I'm not suggesting for one moment that Ivan's code was anything to do with it, I only mention it in order that it may help with diagnosing my problem.

The part of the code I had been playing with was towards the bottom, i.e. changing the font, and comment shape size.
Can't help thinking I've inadvertantly set up excel differently.
I've tried opening another workbook, and shutting down and re-starting, but to no avail.
I'm running windows 98, and excel 2000 premium.

Ta, hoping

Sykes

Hello Sykes..we run the same system.
Not sure what is happening with out knowing what other code is running and on what part of the SS....possible to send example..it's usually easier this way rather then posting back & forth...

 

[sykes]

Hi Ivan
Thanks for the reply.

I've actually re-installed excel, and I think it's fine now.
It seemed to have a bit of a glitch - probably something I did somewhere along the line.

Kind Regards

Sykes

 

[Ivan F Moala]

I'm glad you got it soughted!