Thread: .FreezePanes
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Bob McClellan Bob McClellan is offline
external usenet poster
 
Posts: 6
Default .FreezePanes

Jim,
Thanks for the reply....

I am working in an ActiveX Script within an SQL DTS package
As far as I know, you can not use .Window or ActiveWindow...
--that's the problem

"Jim Thomlinson" wrote in message
...
FreezePanes is supported from the window object. so you need something
like
this...

ActiveWindow.FreezePanes = True
--
HTH...

Jim Thomlinson


"Bob McClellan" wrote:

Hello,
I have been trying without success to get the freezepanes
to work from an ActiveX Script within an SQL DTS package.

I keep getting the error that .FreezePanes is not supported.
I have tried many variations of the following .....

..Splitcolumn = 2
..Splitrow = 11
..FreezePanes = True

any help would be much appreciated....
Thanks in advance,
bob.