hiding columns when printing

[sisterpete]

hopefull this is it for tonight, Paul you have been extremely helpful.

in another application, i am using excel for quotes and invoicing. two fold questions

1. i would like to have a column that shows my cost on items, as well as a column for the price to the customer. is there a way to hide the "cost" column when it's time to print?

the columns would be in this order.

quantity
discription
my cost
unit price
total

the cost column would not need to have anything to do with formulas, just the wholesale cost of the item for my convenience. but i would need to hide it when i printed the quote. even when i email quotes, it would still be "printed", as i print to acrobat and make a pdf to email.


2. is there a simply way to turn a quote into an invoice?

thanks for your time and help.

[Vlad999]

For the first question why dont you just hide the my cost column? Right click on the column letter and select hide

[Paul]

If you want to hide it programatically, you can use something like:

Please Login or Register  to view this content.

This way, if you forget to manually hide the column, it will hide it before you print (or print preview even).

[sisterpete]

do i put this string of code in the cell as a formula?

[Paul]

Nope.. press ALT+F11 to open the VBA window. You should see VBA Project (Your_file_name.xls) in the left-hand pane. Below that you'll see Sheet1, Sheet2, etc.. and then 'ThisWorkbook'.

Double-click on 'ThisWorkbook', then paste this code into the right-hand pane. Close the VBA window, save your workbook.

Click the Print Preview toolbar button, and you'll see that column C has been hidden. If you meant to hide another column, change the "C:C" in the code to that column (e.g. "F:F" or "AR:AR")

[sisterpete]

much thanks.... i'll give this a try

[sisterpete]

believe it or not, i am just getting to try this... i had given up on my excel stuff until now when i had some more time to work on it.

this is the error i am getting trying to hide column "I"

runtime error (9)
subscript out of range

here is what i put in

Please Login or Register  to view this content.

i see my sheet 1 which looks like this... it has my sheet name on it...

Sheet1 (Uhlik Install Quote)

once i understand how to hide a single column, i really need to hide columns I, J, K, L

thanks

:o)