Search results for query: *

Coyoteooc - Problem solved - I was not aware of the iserror function. Thank you very much for your help -Dan

I am referring to the Autocad status bar, which includes options such as Ortho, Grid, Paper/Model etc. When I initially open up Autocad, an error message flashes regarding a failure to update the registry. Apparently this is part, if not entirely the problem. After a little research it seems...

The solution needs to be a formula I do not have to modify - if I have the equation: =Sheet2!A1+Sheet3!A!+A1 and it becomes =Sheet2!A1+Sheet3!#REF!+A1 when a line is deleted on sheet 3, is there a way I can report any cell with a #REF as simply a 0? I was playing around with the...

Here is the situation: I am totaling the sums from several different sections of worksheet 1 onto worksheet 2. Several of the sums on worksheet 1 will be deleted, causing the error #ref on worksheet 2. How do I total the sums, exluding the #ref Thanks- -Dan

Sorry, I was actually looking to just open and close the toolbar - Application.CommandBars("Test").Visible = True Easy enough, thank you for the help anyway- -Dan

OK, but what is the actual code please? Thanks-

Ok, this is ridiculus, but the status bar disappeared, and I cannot find a way to bring it back. What's the story here?

I don't understand - making Toolbar plural doesn't seem to change anything

OK, now it doesn't like the line telling the toolbar to close. What is the correct coding? I would like to open 4 different custom menus at when the workbook is opened, then close them with the workbook.

I am trying to open and close some custom menus - when I run the following, I get the error message below: Private Sub Workbook_BeforeClose() Application.Toolbar("Test").Delete End Sub Compile Error: Procedure Delcaration does not match description of event or procedure having...

You may be right Skip, I have to figure out Pivot Tables first so I'll have to get back to you- Thanks- -Dan

I tried the frozen panes, and it appears everything is unfrozen already.

It may just be my computer. I tried it on another machine and it worked fine. For some reason, on my machine the bottom portion of the drop down is not visible and the scroll will not work. So the first half of the contacts show up, but the second half are unaccessable. I guess this is just...

Here is the situation- I have two drop down boxes, the first box triggers the second. The first drop down contains a list of Geneneral Contractors, the second drop down contains the contacts at each general contractor. There are maybe 15 General Contractors, up to 20 contacts for each. How...

You're right, seems to work fine now- Once again, thank you very much! -Dan

Actually, both of the following lines are there: Private Sub Workbook_Open() FixCustomToolbar "Bidding004" FixCustomToolbar "Functions" End Sub There were 2 custom menus before - one being "functions" the other being "bidding004". Now there is only...

You are right, it does not have the toolbar "Functions" The name is "Bidding004" - but does your code rever to either name? I entered ?application.commandbars("Bidding004").index Response was: 25

Here are the results: ?strToolBar Functions ?typename(application.commandbars) CommandBars

OK, I put the queries into the immediate window and hit return, but the same Run-Time error '5': Invalid procedure call or argument comes up, refering to the same hi-lighted line.

Rob, Sorry, but I'm not real sure on what the procedure is here - I open the workbook, activate macros, and the folllowing error message comes up: Run-Time error '5': Invalid procedure call or argument I hit debug and it takes me to this line: For Each objControl In...