.FreezePanes
Bob,
How are you refering to the other Excel objects then ?
Dim xlApp As Object 'Excel.Application
xlApp.ActiveWindow.FreezePanes = True
NickHK
"Bob McClellan" bl...
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.
|