Runtime error

[aftamath77]

I'm getting a runtime error 438 on a .Show code. All of the sudden the code
on my userform isn't working.

Code:
FormHome.show vbModal

Error:
Run-time error '438':
Object doesn't support this property or method

I have been working on this userform for some time, and just out of the
blue, I started to get this error. Any ideas how to fix this. I'd hate to
have to redo all these hours of work. I'm using Excel 2007

 

[Jim Thomlinson]

Note that the .show did not capitalize. That indicates to me that FormHome is
not a form. Perhaps you have declared it elsewhere as something else???

Try putting Option Explicit at the top of your code modules to catch any on
the fly declartations that were made in error.

 

[aftamath77]

My mistake, simply a typo. The .show is capitalized. I even retyped it, and
the dropdown menu appeared after the period with Show in the list

 

[Dave Peterson]

Did you look to see if there was any other thing that used FormHome as its name?

 

[aftamath77]

Since you mentioned that, I came across some code that was using the Call
Statement. I recoded this so it doesn't use the Call Statement on a sub.
The code runs now, but I'm not sure why Call would cause a runtime error.

 

[aftamath77]

I zeroed it down. It wasn't the .Show problem. It was .DisplayWorkbookTabs.
I got that code by recording a macro, then copying from the Module.

Is there an Add-In or Reference I need to allow ".DisplayWorkbooksTabs."

 

[Dave Peterson]

Nope. That's built into excel.

What was the problem when you used it?

 

[aftamath77]

I was trying to use a specific worksheet. I changed the worksheet object to
ActiveWindow.DisplayWorkbookTabs instead of
Worksheets(Index).DisplayWorkbookTabs

 

[Dave Peterson]

Sometimes VBA's help is nice.

If you search for that property, then click the "Applies to" link, you'll see
that it applies to the window object.

I was trying to use a specific worksheet. I changed the worksheet object to
ActiveWindow.DisplayWorkbookTabs instead of
Worksheets(Index).DisplayWorkbookTabs