another macro?

eddieque · Apr 9th, 2002, 11:10 AM

I would like to have a macro automatically opens Excel in full view. I have create a macro to do that and then called it autoopen but that doesn't work. suggestions?
For a class project.

Tom Schreiner · Apr 9th, 2002, 11:15 AM

Post your code Eddie
Application.Windowstate = xlMaximized
or something like that...
Tom

eddieque · Apr 10th, 2002, 07:28 AM

here is the code I am using. The code you gave will maximize the the workbook when I assign it to a button, but it will not automatically run when I open the workbook and that is what I want.

Sub autoopen()
'
' autoopen Macro
'
'
Application.DisplayFullScreen = True
End Sub

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

Apr 9th, 2002, 11:10 AM	#1
eddieque New Member Join Date: Feb 2002 Posts: 26	I would like to have a macro automatically opens Excel in full view. I have create a macro to do that and then called it autoopen but that doesn't work. suggestions? For a class project.

Apr 9th, 2002, 11:15 AM	#2
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Post your code Eddie Application.Windowstate = xlMaximized or something like that... Tom

Apr 10th, 2002, 07:28 AM	#3
eddieque New Member Join Date: Feb 2002 Posts: 26	here is the code I am using. The code you gave will maximize the the workbook when I assign it to a button, but it will not automatically run when I open the workbook and that is what I want. Sub autoopen() ' ' autoopen Macro ' ' Application.DisplayFullScreen = True End Sub