How to Maximize an Excel window and set it as preference i..

External Since: Aug 18, 2006 Posts: 18

JE McGimpsey wrote:
> In article <1156804433.884252.157540.RemoveThis@i3g2000cwc.googlegroups.com>,
> "whitecloud1" <jbonner.RemoveThis@oceanfree.net> wrote:
>
> > Thanks again. I mentioned I had a problem when I followed your
> > instructions:
> > On opening a new file I get the following message:
> >
> > Compile error: User-defined type not defined.
> >
> > In the "This Workbook" (Below sheet 1 in Microsoft Excel Objects) the
> > followin is highlighted in blue: New WindowHandler
> > If I press Ok, then the first line is highlighted in yellow with an
> > arrow pointing to it:
> > "Private Sub Workbook_Open()"
> >
> > Have I misinterpreted your instructions somewhere?
> > How do I name the created file MyWindowHandler or whatever you said?
> > Is it done by the visual basic code anyway?
>
> Yes, you misinterpreted my instructions. WindowHandler is not a file
> name, it's the name you assign to a Class module (using the property
> browser in the Visual Basic Editor). Class modules (which you can
> generate using Insert/Class Module) are different from regular code
> modules in that they define a class object which can then be used to
> create additional objects.
>
> By creating an object and assigning it to the clsMyWindow, using
>
> Private Sub Workbook_Open()
> Set clsMyWindow = New WindowHandler
> End Sub
>
> in the ThisWorkbook module of your Personal Macro Workbook (or, as I do
> it, my startup add-in), you establish an object that contains a
> WithEvents variable (oApp) that responds to application-level events,
> such as _WorkbookOpen
>
> I put a slightly modified sample add-in at
>
> ftp://ftp.mcgimpsey.com/excel/whitecloud1_demo.xla
>
> Put it in your startup folder. It's unprotected so you can set
> breakpoints and see how it works.

Thanks for the add-in. It only worked when I removed the Personal macro
workbook from the Excel folder of Startup. If I could modify the script
to open at 150% and move it slightly up and to the right it would help.
I had already set my "Workbook" default to open at 150% and this script
was reducing new files after opening.

I tried changing the Class module name from 'Class 1" but it is
impossible to do this in the browser without Excel shutting down as a
result. I don't know how you renamed yours. Perhaps I'll try this in
Windows and maybe transfer it to mac??

At this stage an "automatic setting" is just an intellectual challenge
for me, as I have already set a 3-key keyboard macro to move any opened
excel file (all at 150% now anyway) a little up and to the left.
I think I'll give up on it for now.

Best wishes,
John.

External Since: Mar 07, 2004 Posts: 3828

In article <1156879725.311277.11730.DeleteThis@p79g2000cwp.googlegroups.com>,
"whitecloud1" <jbonner.DeleteThis@oceanfree.net> wrote:

> I tried changing the Class module name from 'Class 1" but it is
> impossible to do this in the browser without Excel shutting down as a
> result. I don't know how you renamed yours. Perhaps I'll try this in
> Windows and maybe transfer it to mac??

This was a known bug when Office 2004 was first released, but subsequent
updates have fixed it. Are you using an updated version of XL? Use
Office Autoupdate if not - there are a number of small fixes.