Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TugboatEng on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Hiding columns in a BOM

Status
Not open for further replies.

mrkoko

Mechanical
Joined
Aug 3, 2007
Messages
40
Location
CA
Does anyone know of a way to hide columns in a BOM so that they do not appear when printed but do appear when you save the BOM out to an excel or a csv file. I am on SW 2009 sp2

Thanks,
 
AFAIK, the only way is to unhide the columns before exporting.
 
bueller .... bueller ?
 
You can create two copies of BOM Table (one for export and one for printing) and customize them. Next hide/show one of them in FM Tree depending on the situation (printing or exporting)

Artem Taturevich
CSWP
 
ah, thanks ! I really had no idea on that one. A friend though they remember being able to do it with a $PRP$ or something to that effect in the header row of the BOM but I can't find any documents to support that, nor can I get it to work.
 
Can you move the non-printing columns to the right? If so, then set a Print Area (in Excel) for only the desired left-columns.

Otherwise you'll need a macro (actually probably an add-in if you want to use this across many files).

Ken
 
As Artem said previously, just create 2-bom tables. No need to hide either table. For the exported table just drag it off of the drawing sheet and it will not print.

Andrew
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top