Replies

Thank you Charles,
I will give it a try this week en let you know if you solved my problem.

Hello Andrew,
I know I can solve it with VBA, but I want to avoid this.
I hope the is an easy in document formula solution.

Thanks Rory,
It works!

greetings,
Patrick Schouten
The Netherlands

Hello Paul,

Even after searching and reading al lot of posts, I did not find this one.
So thanks for pointing me to it. It seems in de code is enough information for me to create my own code.

greetings,
Patrick Schouten
The Netherlands

PS, how do I mark this thead as [solved]?

Paul and Andrew,
Thank you both for your quick respones.
This code will get me further.

Greetings,
Patrick Schouten
The Netherlands

Try Pieterse’s [post=”290455″]Systematic Approach to behavioral Problems in XL[/post].

Yep… Deleting the XLB file corrected my problem.
So now I have can change Excel to the way I like it again.

Again, Thanks Hans

Patrick

I haven’t seen Excel 2009 yet

Try Pieterse’s [post=”290455″]Systematic Approach to behavioral Problems in XL[/post].

Thanks I changed it in 2003
I will have a look and see if the XLB file could be the problem

Patrick

Thanks,

It works.

greetings,
Patrick

Hallo Hans,

Thanks for the quick and correct response.
It is working great.

Greetings.
Patrick Schouten
The Netherlands

Hello Don,

Thanks for your reply.
Unfortunately I am not able to check this because of restrictions our company sets on user accounts.
But I will discuse this later on with out IT department.

Hans,

Thanks for the effort.
My conclusion is that this seems to be a local problem. So I will take it up with our IT department.
Thanks

Hello Hans,

No, I create to buttons by hand in the document and than change the properties to give them a proper name.

You are a livesaver.
Thanks, you hit the nail on it’s head

Hans and Jan Karel,
I’m sure that the solution of Hans will work, but i’m using the short version of Jan Karel.
It works perfect.
Thanks.

Hello Hans,

You are a livesaver.
Thanks it works perfect