Run time error 1004 ????

Robin of Oxford · Apr 1st 2003

I've got an excel file that, on workbook open, goes to full screen, loses the command bars, status bar, etc. to make it look a bit like a 'standalone' product. I've got some navigation buttons at the time to switch between sheets. Each sheet has a worksheet_activate command to show or hide certain toolbars, etc. for example:

Private Sub Worksheet_Activate()
With ActiveWindow
.DisplayGridlines = False
.DisplayHeadings = False
.DisplayHorizontalScrollBar = False
.DisplayWorkbookTabs = False
.DisplayVerticalScrollBar = True
End With
Application.CommandBars("Standard").Visible = False
Application.CommandBars("Formatting").Visible = False
Application.CommandBars("FACT Print").Visible = True
Application.DisplayFormulaBar = False
Application.DisplayStatusBar = False
End Sub

I've had no problems on a number of PCs at my office, but my client's PC is having error messages. When you click to navigate between sheets, sometimes I get "Run time error '1004', unable to set <code line> property of the windows class" but not always on the same button. If I hit debug and delete the code line, I get the same message with the next line.

I added the line 'on error resume next', which stops the error messages, but I'd like to know what the issue is.

Thank you. (sorry for the long winded question !!!)

Will Riley · Apr 1st 2003

Well, until someone comes up with something better - All I can offer is an explanation (as per Microsoft) of the Error Message itself, in the hope that it helps the debugging process..

Quote

[Method name] method of [object] class failed (Error 1004)
An external error occurred, such as a failure to read or write from a file. The method cannot be used on the object. Possible reasons include the following:

An argument contains a value that isn't valid. A common cause of this problem is an attempt to access an object that doesn't exist [for example, you tried to use Workbooks(5) when there were only three workbooks open].
The method cannot be used in the applied context. For example, some Range object methods require that the range contain data; if the range doesn't contain data, the method fails.
An external error occurred, such as a failure to read or write from a file.
For more information about the method, search Help for the method name.

Display More

Hope this helps

**royUK** · Apr 1st 2003

How do your navigate buttons work?

Are they hyperlinks to pages that have been deleted or renamed?

In case it is a fault with your navigation, have a look at my alternative solution on this post

http://ozgrid.com/forum/viewthread.php?tid=1456

Roy

Richie(UK) · Apr 1st 2003

Hi,

I think Roy is on the right track here.

What sort of buttons are you using to navigate between the worksheets? If you are using CommandButtons try setting the TakeFocusOnClick property to False (its True by default). Or, try using a button from the Forms toolbar instead.

HTH

Insomniac · Apr 1st 2003

You might also try adding:

Activecell.activate

as the 1st line of code to ensure correct focus.

Run time error 1004 ????

Participate now!

Share