What is wrong

[deanl33069]

Application.Worksheets("Sheet5").DisplayFullScreen = True
keep getting subscript out of range error
plz help

 

[Fluff]

How about

Application.DisplayFullScreen = True

 

[deanl33069]

ty , but i need an specific worksheet to open not the active one.

 

[Joe4]

Just select that sheet first, i.e.

[COLOR=#333333]Sheets("Sheet5").Activate
[/COLOR]Application.DisplayFullScreen = True

 

[deanl33069]

Tried it but got nowhere here is my complete code.....it is in a form if that make a difference

tyvm


Private Sub commandButton1_Click()
Sheets("Sheet5").Activate
Application.DisplayFullScreen = True
Application.CommandBars("Full Screen").Visible = False
'Range("C2").Select
Range("C2").ClearContents
Range("n2").ClearContents
Range("b5").ClearContents
Range("c3").ClearContents
Range("a6:a460").ClearContents
' Range("C2").Select
Me.Hide







End Sub

 

[Joe4]

What is it exactly that you are trying to accomplish?
I seldom work with Forms (I find them rather cumbersome in Excel, and prefer to use Access if I need Forms), but try putting those two lines AFTER the "Me.Hide" line.

 

[deanl33069]

ty got it
and yes i am learning that excel forms aren't real friendly!!!

 

[Joe4]

You are welcome.

I just find them a bit cumbersome to work with, as you need to explicitly link them to Excel using VBA. In Access, form fields can automatically be "bound" to table and query fields (no need to manually map them).