Datasheet: Freeze columns runtime from VBA

[ib.c.bank]

Hi,

any idea to freeze a specific column in a datasheet form?

Best regards
Ib

 

[Maurice]

Rightclick columnheader and choose 'Freeze column' i think.

 

[ib.c.bank]

Rightclick columnheader and choose 'Freeze column' i think.

Well yes, I can do that. But what I want to do is freezing some
columns just before the form is opened.

 

[Maurice]

Ok, sorry for the 'lame' reaction. The columnfrozen is a read only attribute
and can not be set at runtime. So I think you are out of luck there...

hth

 

[SteveM]

It is posiible to do this, visit this link:
http://msdn2.microsoft.com/en-us/library/aa217449(office.11).aspx

Steve

 

[Maurice]

Hi Steve,

You are right. I've read the article. It's possible but you have to do quite
some checking to see if the user didn't freeze any columns before. Tricky but
it can indeed be done...

Thanks for pointing out.

 

[SteveM]

No probs, only just found out myself!
It was posted on another forum...

Steve

 

[ib.c.bank]

Hi Maurice and Steve

Thx for your comments. It solved my problem

Cheers
Ib