| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Not Printing cells
Hello, i am automating with Foxpro. everything is fine with one exception. i
have a formula in column G, i am hiding it from viewing, but it still prints out and i need it not to. how do i go about this? thanks in advance. Tom |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Not Printing cells
How are you hiding it from viewing?
-- Regards, Tom Ogilvy "Tom" wrote in message ... Hello, i am automating with Foxpro. everything is fine with one exception. i have a formula in column G, i am hiding it from viewing, but it still prints out and i need it not to. how do i go about this? thanks in advance. Tom |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Not Printing cells
osheet.Columns("G:G").Hidden = .T.
"Tom Ogilvy" wrote: How are you hiding it from viewing? -- Regards, Tom Ogilvy "Tom" wrote in message ... Hello, i am automating with Foxpro. everything is fine with one exception. i have a formula in column G, i am hiding it from viewing, but it still prints out and i need it not to. how do i go about this? thanks in advance. Tom |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Not Printing cells
I know .T. is true in foxpro, but it isn't in COM I wouldn't think. Try
oSheet.columns("G:G").Hidden = -1 -- Regards, Tom Ogilvy "Tom" wrote in message ... osheet.Columns("G:G").Hidden = .T. "Tom Ogilvy" wrote: How are you hiding it from viewing? -- Regards, Tom Ogilvy "Tom" wrote in message ... Hello, i am automating with Foxpro. everything is fine with one exception. i have a formula in column G, i am hiding it from viewing, but it still prints out and i need it not to. how do i go about this? thanks in advance. Tom |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cells not printing | Excel Discussion (Misc queries) | |||
| Not-printing cells/formulas | Excel Discussion (Misc queries) | |||
| Printing Unprotected Cells Only | Excel Discussion (Misc queries) | |||
| printing cells | Excel Worksheet Functions | |||
| printing not within the cells | Excel Discussion (Misc queries) | |||
Linear Mode
