Excel registry settings for size/pos

[cellon]

i figured out how to adjust the position and size of the actua
workspace of excel, but i would like to be able to specifiy that exce
automatically resize the window within the workspace t
"maximize".....here's the reason.


the software we produce comes with automatic excel sheet output fo
archiving purposes...so we wanted to find a way to also build in
function capable (independant of whose machine it is running on, whic
is the important part) of modifying the reg key for this windo
size.....

if anyone could help, i'd appreciate it

 

[Immanuel]

Check

HKEY_CURRENT_USER\Software\Microsoft\Office\<version>.0\Excel\Options\Pos

where <version> is the version of XL you're targeting.

/i.

 

[J.E. McGimpsey]

Frankly, if you had the temerity to touch my registry for your one
application (*ESPECIALLY* if it's just for "archiving purposes"),
I'd trash your application, stop payment, and charge back the time
needed to go through all the machines on my network to fix your
change.

Not to mention that changing the registry will not work
cross-platform, so it won't be "independant of whose machine it is
running on".

Why not include this Workbook_Open macro in the ThisWorkbook module
of your output workbook instead?

Private Sub Workbook_Open()
ActiveWindow.WindowState = xlMaximized
End Sub