Posts by briaNRDonohue

I would like to be able to password protect my workbook in excel so I am the only one able to open it.

OK guys thank you for your help.

-Brian

What are the extra files that get saved when you save as web page? Can I get rid of them or make it so they don't save?

thank you guys for your help.

is there a way that i can save a page from a workbook as a pdf file?

-Brian

Thank you that worked really well

-Brian

I'm not sure what I did wrong but that didn't seem to work.

I'm trying to format a cell to have the sufix square inches but for some reason it will not let me. why is that or how can I right squared with a superscript.

-Brian

thank you for your help it all worked out I'm sure I'll be back with another question soon, thanks again.

-Brian

I'm trying to find a way to hide about 18 rows that equal zero in column A, its probably really simple but I can't think of how to do it.

-Brian

Thank you I will do that and let you know how it worked out for me.

-Brian

I was wondering if there is a way to record a macro on to a sheet then have it automaticly start whenever you go to that sheet.

-Brian

yes that does work thank you for all of your help.

-Brian

Well right now I have it set up on sheet 1 so when you push one of the buttons on the custom toolbar it will run the macro for that model but when I recorded the one for the multi tube it stopped at that long formula. So essentaily what I'm doing is copying everything from the other 3 sheets that where my out put pages and making it into one simple sheet. Iwill also have the same problem when I do the V Tube because in the same spot on that one there is an even longer formula(which you can see on the Mini, Multi,V Tube sheet). Right now I'm working on making them shorter hoping that will work.

Hi I'm having a problem when I record a certain macro I've tried it several times and it wil stop and tell me I have a run time error. It always shows me that this formula is the one with the error: =IF(C21="None",0,IF(C18="HE 495",VLOOKUP(C21,Hide!R31:S32,2,FALSE),IF(OR(C18="HE 645",C18="HE 745"),VLOOKUP(C21,Hide!R29:S30,2,FALSE),IF(OR(C18="HE 986",C18="HE 1256",C18="HE 1436",C18="HE 1796",C18="HE 2066"),VLOOKUP(C21,Hide!T29:U30,2,FALSE),0)))) and when I look at it only half of it is there like it was just cut off, is it because the formula is too long? I hope this isn't too vague, here is an attachment of what I'm talking about.

well I was getting a runtime error and the formula is giving the wrong cells but I just lost everything about 30 mins. ago somthing happened to my excel. so you can ignore this now, I'm really sorry to waste your time like this I feel really bad. Thank you though for your help and again I'm very sorry.

-Brian

I was wondering if someone could help me with this I don't know whats wrong with it because I don't understand VB. ActiveCell.FormulaR1C1 = _
"=IF(RC[-3]=""None"",0,IF(R[-3]C[-3]=""HE 495"",VLOOKUP(RC[-3],Hide!R31C18:R32C19,2,FALSE),IF(OR(R[-3]C[-3]=""HE 645"",R[-3]C[-3]=""HE 745""),VLOOKUP(RC[-3],Hide!R29C18:R30C19,2,FALSE),IF(OR(R[-3]C[-3]=""HE 986"",R[-3]C[-3]=""HE 1256"",R[-3]C[-3]=""HE 1436"",R[-3]C[-3]=""HE 1796"",R[-3]C[-3]=""HE 2066""),VLOOKUP(RC[-3],Hide!R29C20:R30C21,2,FALSE),0))))"

Thank you so much I tried it and it worked.

will that still keep the values from that page relative?

I'm having a problem with a macro that I'm trying to run. When I run the macro in the spot that I recorded it it works but if I start it from a different cell all of my formulas change. The thing is I would like for parts of the formula to change like the values that I'm pulling off of that page, but I don't want the references to tables I have on seperate pages to to be changed relative to the cell I start in. Is there anything I can do?