Email:      Pass:    Pass?
Close Window   
TE
Subscribe for Email Updates!
Excel tips, help, and more!
E-mail:


Advertisements


Free Excel Forum

Print Protection???

Forum Register
Search Excel Forum Posts, Tutorials, Macros, Tips, and More

I need to protect an Excel document from being printing. Is it possible?


View Answers     

Similar Excel Video Tutorials

Helpful Excel Macros

Complete Guide to Printing in Excel Macros - PrintOut Method in Excel
- This free Excel macro illustrates all of the possible parameters and arguments that you can include in the PrintOut Meth
Print Preview Screen Display for The Current or Selected Worksheets in Excel
- This free Excel macro allows you to display the print preview screen or window for the current or selected worksheets in
Print Preview Screen Display for The Entire Workbook in Excel
- This free Excel macro allows you to quickly and easily display the print preview window or mode for the entire Excel wor
Print Specific Pages in Excel
- This free Excel macro allows you to print a pre-specified selection of pages from Excel. This means you can print 2 pag
Open a Word Document from Excel
- This Microsoft Excel macro will open a Microsoft Word document from excel. With this macro, you can open any word docume

Similar Topics







Hello,
We are having a serious issue printing from an excel document. Each time we try to print from the print icon or print preview menu, the cells and row information shifts. The text and the shapes would shift off to the right. The spreadsheet will print out ok, but the docment itself will be left offset. We've tried reinstalling the printer driver,printing from a different printer,running all of the ms office updates, and printing frome different pc's. The only thing in common is that each pc is on the excel 2003 version. I've tried printing from the 2007 version of excel and had no problem. Could this be a version issue or wait. If anyone out there could help us out with this, your expertise would be greatly appreciated.

TKris




I have a Document with multiple sheets in it and I ask it to print entire document which would be 7 sheets (1 Page printed per sheet) but only the first five will print, then it comes up with a second print queue that I need to use and OK to print the balance of them with. I'm printing To a PDF creation program. it saves and Prints the first 5 pages then asks for another new name of the document to save the next few pages. my PDF Creator works fantastic with any other program. I just need to know how to tell it to print as many sheets as I have to print without it doing that. so I can print all sheets in a single PDF document.



I have a Document with multiple sheets in it and I ask it to print entire document which would be 7 sheets (1 Page printed per sheet) but only the first five will print, then it comes up with a second print queue that I need to use and OK to print the balance of them with. I'm printing To a PDF creation program. it saves and Prince the first 5 pages then asks for another new name of the document to save the next few pages. my PDF Creator works fantastic with any other program. I just need to know how to tell it to print as many sheets as I have to print without it doing that. so I can print all sheets in a single PDF document.

Hi Community, I have found some informations regarding Excel Document Properties and how to create, edit and delete via VBA - but what I am looking for is: How to protect them!? I want to set the document properties to clearly show that it is MY document and dont want anybody to change that...
Is there any smooth way aside the normal workbook protection with password?

Many thanks in advance for your feedback!


I am printing a document in Excel with the gridlines bolded. However, when I
Print the document it shifts the text in some cells down so they sit on the
line. How do i fix this? Also just for reference i am using excel 2003 and
we are using a windows 2000 print server.





I'm using excel and trying to print a document with the print to fit function
and this works, however only utilizes half of the page, the top part of the
page in print preview, hence making the document to small and unlegible. If
I could stretch this document over the whole page I could then read it.



Hi Guys,

I have created a document which I have to send out to a number of people each month. They have to print this document.

Is there a way to set print margin settings for the document so that when the document is emailed to someone, it will print off on their computer in the format I want it to?

I know I can set it as default for my computer, but I want to set the printing settings to the document. Im not sure if this can be done.

Any thoughts or advice?

Cheers,
Cordo.


When I select print on an Excel (.xls) document in Explorer, or right-click
Print an excel icon in Exchange, only the first sheet is printed. Is there a
default I can change so that these actions print ALL (non-blank) sheets?

(I know that I can open the document and Print all sheets from the Print
dialog. I want to accomplish this printing without explicitly opening the
document.)

Thanks!



Hello,
We are having a serious issue printing from an excel document. Each time we try to print from the print icon or print preview menu, the cells and row information shifts. The text and the shapes would shift off to the right. The spreadsheet will print out ok, but the docment itself will be left offset. We've tried reinstalling the printer driver,printing from a different printer,running all of the ms office updates, and printing frome different pc's. The only thing in common is that each pc is on the excel 2003 version. I've tried printing from the 2007 version of excel and had no problem. Could this be a version issue or wait. If anyone out there could help us out with this, your expertise would be greatly appreciated.

TKris


Excel 2000 is having problems printing comments that are part of a protected
worksheet. I am trying to print comments "end of worksheet". With the
worksheet protection set to protect only "contents", comments are not printed
except for the first cell. What does print is the reference for each cell
that actually has an associated comment, but the comments themselves do not.

Anybody have any ideas about how I can correct this?



Hi,

Please help...

I have created a very simple macro to print out a whole document. However, rather than just printing out if someone pressed the button by accident, I would like to create a pop up box saying something like:

"Are you sure you would like to print the Whole document?"

Options to select:

"Yes, Print entire Document"
or
"Cancel"

Please advise...

Many Thanks

Tom


I have a workbook set up to allow my team to print a document based on information they put in. I have disabled the save option as I want it to default to an original each time they open as there are multiple users. Basically the populate some cells and the display in the document below it for printing.

Is there a way to save a selection for printing if they want to print it at a later date?


I have a co-worker who is having problems with cell borders not printing.

Her document originated in Excel 2000. We have upgraded to 2003 and she
continues to use this same document in 2003.

Occasionally when she prints, her borders do not print. Sometimes this
happens when rows are hidden within this area that is bordered. Also,
normally she is only printing a selected portion of the worksheet. Could
hidden rows or printing selected cells affect the borders?

What are some of the reasons why borders don't print?
--
L Lightner



I have an excel document that has 10 worksheets. I cannot print worksheet
number 8. Even if I copy it to another excel document it will not print. I
can see the document in "print preview" but when "print" is selected the
printer starts but only blank pages are produced.

What do I need to do to print this worksheet?

Thanks
C. P.



Is there a way to print an entire workbook as one document?

I have about 20 worksheets, and the macro I use now gives every sheet first a contentdepending pagesetup, and then loops through the sheets and prints them as separate pages.

If I print to a pdf-writer for instance, I get 20 separate pdf files, instead of one. So, is there a way of printing one workbook as one document?




Hi

I use a spreadsheet to generate estimates, half of which I send out by email and the others I print and post. for the email estimates I add a picture of my headed paper as a header before I print to pdf. I'm happy with how this works but does anyone know of a quick way to leave the header permanently on my template just not have it print if I'm physically printing the document but have it print if I'm printing to pdf?

Thanks

Mick

Hi,

I was wondering if anyone has ever expericed an excel document that doesn't completely print to pdf? It prints fine to the printer but when printing to pdf a fair amount (around 2 inches) of the bottom gets cut off (print preview shows it cut off too).

It only happens to this document but with various versions of office and pdf writers. I've attached a copy of the file and here's a link: http://www.movecommunications.com/ex/pdfcutoff.xls if anyone has any ideas.

Thanks so much!


I'm trying to print an Excel document as a PDF file. The page itself is rather large so when I print to my physical printer I select "scale to 1 x 1 pages" on Excel's page setup.

However, when I use this setting to print as a pdf it cuts off the bottom quarter of my document. Can anyone help?

thanks!


I have created checkboxes in Excel using the form function. When I go to print it will only print check boxes randomly and typically only at the top of the page. I have checked Print preview and the boxes are there. If I print one page at a time than it will print all the boxes on the page, but it is not feasible to ask people to print one at a time. When I go back to printing the whole document it goes back to randomly printing checkboxes.

Any thoughts? Please and thank you!


I would like to set printing preferences to FastDraft permanently so that I do not have select each time I want to print a document. Current settings are at FastNormal and I have to change them every time I want to print something. Setting them from Control Panel=>Printing Preferences does not seem to do the trick for Excel although it does for Word. I am at a loss, pleaaaaaase help!!!


Hi,
This form is really helpfull friends..

I want to know,
Can we print Excel document in DOS base? By command or so...

If yes how? What will be the command if document named ABC on desktop.

I use DOS based printer and its fast to print if we can print on DOS base.


Hi Experts!!

I'm haing a problem in printing excel document once i print it appear as faint.
Also i want to make a calculator using excel 2007. How can i do?


Does anyone know if when you protect an excel document, how do you protect the Header and Footer. I am able to protect the document which falls between the header and footer but I am unable to protect the header and footer.
Excel 2007 please help.


Hi There

in my spreadhsheet I want to open a word document from Cell A1 which has a hyperlink and then want to print that document. I have got as far as opening this document but can not get it to print it. Code:

Dim link As String
On Error GoTo error1
link = Worksheets("Sheet1").Range("A1")
ActiveWorkbook.FollowHyperlink Address:=link
Exit Sub
error1:
MsgBox "There Is No Doucment Attached To This Service User", vbOKOnly


This code open up the document but now I want to print this document. any help would be appreciated.


Hi everyone!
Here is what I need: We have a set of documents, all pdf files, residing in a network server. The shipping personnel will have a Laserjet 8150 ND (also on the network) to print the document they need at the time of shipment, for a specific product (the pdf files are actually User's Manuals for various products we sell).

We would like to create an Excel form, listing those documents, with a selection method to indicate which document is to be printed and how many copies. Then clicking on a "PRINT" button will send a command to the printer to print the desired manual.

I searched the forum threads and noticed that the subject mostly deals with printing TO pdf, whereas my need is to print pdf FROM Excel, but no such a command exists.
Is that possible? and If so, any hints you can throw my way, please?

Thank you all.
Chuck