Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Excel, screen position -- upper left hand corner
Message
 
À
18/08/2004 04:58:23
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00933872
Message ID:
00934171
Vues:
25
Cetin,
Are you still with the Marine Institute?

>>Hi,
>>Is is possible to tell Excel to make a certain cell be the upper left hand
>>corner of the scren?
>>Thanks
>>Steve
>
>Use GoTo with 2nd parameter TRUE. ie:
>
>ox=CreateObject('excel.application')
>With ox
>  .Workbooks.Add
>  .Visible = .T.
>  With .ActiveWorkBook.ActiveSheet
>     .Application.GoTo(.Range('F200'),.T.) && Make F200 upper left cell
>     * Limit scrollable area
>     * .ScrollArea = 'F200:K300' && User cannot scroll and select out F200:K300
>  endwith
>endwith
>
Cetin
Imagination is more important than knowledge
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform