The AccuTerm forum has moved. Go to community.rocketsoftware.com to register for the new Rocket forum. |
Object Bridge FreezePanes in Excel |
Post Reply |
Author | |
Colvy
Newbie Joined: September 14 2015 Location: Arlington, TX Status: Offline Points: 9 |
Post Options
Thanks(0)
Posted: January 15 2016 at 6:52am |
I have tried to freeze the top row of an Excel spreadsheet using the Object Bridge subroutines, but it does appear to be working. Does anyone have any suggestions?
* Freeze the top 1 rows: (DOES NOT WORK!) CALL ATGETPROPERTY(Worksheet, 'Rows':SVM:'2',WSROWS,ERRMSG,OPTS) ;*** Set rows to 1 past the last heading line CALL ATGETPROPERTY(WSROWS,'ActiveWindow',ACTIVE.WINDOW,ERRMSG,OPTS) CALL ATSETPROPERTY(ACTIVE.WINDOW,'FreezePanes','1',ERRMSG,OPTS) ;*** 1=True, 0=False Does anyone have any documentation on the passed variables to the ATGETPROPERTY and ATSETPROPERTY subroutines? Thanks!
|
|
Colvy
|
|
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |