Help! - Macro for opening the 'open window'

Gilb · Apr 7th, 2002, 06:53 AM

Can anyone help me with this? (It's probably really simple but I can't figure it out!)
Thanks

Dave Hawley · Apr 7th, 2002, 08:01 AM

Hi Glib

Is this what you mean?

ActiveWindow.WindowState = xlMaximized

_________________
Kind Regards
Dave Hawley
OzGrid Business Applications
Microsoft Excel/VBA Training

[ This Message was edited by: Dave Hawley on 2002-04-07 07:02 ]

willlobb · Apr 7th, 2002, 09:08 AM

Is that you jenny? (from the Isle of Man). if it is, stop cheating!! only joking.
sorry if its not who im thinking of!!
Will

Gilb · Apr 8th, 2002, 01:20 AM

Thanks!! It works now!! =)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 7th, 2002, 06:53 AM	#1
Gilb New Member Join Date: Apr 2002 Posts: 2	Can anyone help me with this? (It's probably really simple but I can't figure it out!) Thanks

Apr 7th, 2002, 08:01 AM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi Glib Is this what you mean? ActiveWindow.WindowState = xlMaximized _________________ Kind Regards Dave Hawley OzGrid Business Applications Microsoft Excel/VBA Training [ This Message was edited by: Dave Hawley on 2002-04-07 07:02 ]

Apr 7th, 2002, 09:08 AM	#3
willlobb Board Regular Join Date: Mar 2002 Posts: 103	Is that you jenny? (from the Isle of Man). if it is, stop cheating!! only joking. sorry if its not who im thinking of!! Will

Apr 8th, 2002, 01:20 AM	#4
Gilb New Member Join Date: Apr 2002 Posts: 2	Thanks!! It works now!! =)