Entire workbook to PDF while keeping individual tabs and formatting

Hi All,

I have a spreadsheet that I want as secure as possible to stop people editing it before they print (or at least make it very difficult)
What I do now as my best solution is to password protect each individual sheet as I can't seem to do an all in one protection or all sheets.
I've tried converting to PDF but that loses the formatting and consolidates everything in one continuous scroll (losing the individual sheets/tabs)

I have excel 2013.

Is there an easy way to just lock down a workbook to stop editing or is what I'm doing the easiest way --- individually password protecting each sheet? It's fine as a once off but surely there's an easier way?

thank you.

why not try.

1. open workbook
2. go to FILE > Save As
3. select location where you would like to save
4. Just to the left of the save button there should be a drop down box that says "Tools"
5. Select tools, and then Select General Options.
6. You can add a password to modify so no one can modify.
7. You can also select read only recommended which may be beneficial as well.
8. After making selections Hit OK
9. Click Save.

Thanks, I used to do that but then someone can open the file as read only and edit it and print their edited version or else just click save as... and save their new copy.
I'm trying to add some sort of standardised/audit proof system. I circulate sheets to a team of people and have discovered people going aroind with versions that I did not create so I want to put a process in place to stop it.
It's probably only 1 or 2 people in 50 who do it. For the rest, the read only option would be enough!

After much research i think they way you are doing this is currently the only other way, unless you invest in 3rd party software. My only suggestion would be to streamline your process by adding a Macro that will protect all sheets in your workbook at once with one click of the button, vs doing it yourself for every worksheet.


Take this Macro below and save it to your PERSONAL.xlsb file so that it will always open in the background and you can access it whenever you need.
to input the password you want change the 12345 to whatever you want the password to be. Make sure you leave the quotation marks though. This will protect all worksheets in your excel file with the click of one button.

Please Login or Register  to view this content.