Datasheet: Freeze columns runtime from VBA

  • Thread starter Thread starter ib.c.bank
  • Start date Start date
Rightclick columnheader and choose 'Freeze column' i think.
Click to expand...
Well yes, I can do that. But what I want to do is freezing some
columns just before the form is opened.
 
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
 
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.
 
Back
Top