disable print preview while printic excel as tif

[prabhuduraraj09]

Hi experts,

I always print a excel file, the content as tif. But when everytime.. i do Ctr+p it ask for a path to save...
once i select a path and give save. Automaticaly...file saves and generates preview of the the file.
But i dont want that print preview to get generated.

i need is...once i give ctrl+p it should ask for a path...and i should save it.. that is all.
I dont want that print preview to get generated.

Is there a option.. i could choose for... to disable..? or i should go for any vba coding help.
pls...resolve my query.

thank you all.

[TMS]

What are you using to create the PDF file?

[prabhuduraraj09]

What are you using to create the PDF file?

im just printing the file, so that it could save as in image format as .tif.
so that rest of the users who could view it..so that they cant modify anything.

ok i will give you clear information. while i kept my file open.
i wil do below steps,
1) Ctrl + p
2) select - Image document writer
3) give ok
4)Browse for save path
5) and after choosing the path....click save

it should stop till that... but after i save.... automaticaly... a preview appears . i should close it each time....when i print the file..to the path.

hope above information clarifies...