+ Reply to Thread
Results 1 to 4 of 4

Entire workbook to PDF while keeping individual tabs and formatting

  1. #1
    Registered User
    Join Date
    10-24-2019
    Location
    Ireland
    MS-Off Ver
    2013
    Posts
    12

    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.

  2. #2
    Valued Forum Contributor dosydos's Avatar
    Join Date
    12-09-2015
    Location
    Massachusetts
    MS-Off Ver
    Microsoft Office 365
    Posts
    1,161

    Re: Entire workbook to PDF while keeping individual tabs and formatting

    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.
    Attached Images Attached Images

  3. #3
    Registered User
    Join Date
    10-24-2019
    Location
    Ireland
    MS-Off Ver
    2013
    Posts
    12

    Re: Entire workbook to PDF while keeping individual tabs and formatting

    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!

  4. #4
    Valued Forum Contributor dosydos's Avatar
    Join Date
    12-09-2015
    Location
    Massachusetts
    MS-Off Ver
    Microsoft Office 365
    Posts
    1,161

    Re: Entire workbook to PDF while keeping individual tabs and formatting

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Autofilter VBA Macro to filter out individual columns across entire workbook
    By prnetreba in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-20-2017, 06:45 PM
  2. [SOLVED] Need Macro to help split data into multiple tabs, while keeping headers, formatting, etc
    By Centara in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-15-2016, 04:37 PM
  3. Copy entire worksheet from one workbook to another, keeping layout and format
    By SamsTechAnswers in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-02-2012, 08:53 PM
  4. Breaking out tabs of a workbook and keeping the links into individual workbooks
    By ozne99 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-29-2012, 03:02 PM
  5. How to have a macro print output to individual tabs in a new workbook?
    By RG Series in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-23-2012, 10:34 AM
  6. Replies: 2
    Last Post: 02-02-2012, 01:22 AM
  7. Generating individual tabs of each state from master workbook
    By harrywaldron in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 01-12-2010, 02:40 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

X vBulletin 4.1.8 Debug Information

  • Page Generation 0.06094 seconds
  • Memory Usage 8,963KB
  • Queries Executed 16 (?)
More Information
Template Usage (35):
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_global_above_footer
  • (1)ad_global_below_navbar
  • (1)ad_global_header1
  • (1)ad_global_header2
  • (1)ad_navbar_below
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)ad_thread_first_post_content
  • (1)ad_thread_last_post_content
  • (1)bbcode_code
  • (1)footer
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)headinclude_bottom
  • (4)memberaction_dropdown
  • (1)navbar
  • (4)navbar_link
  • (4)navbar_noticebit
  • (6)option
  • (1)postbit_attachment
  • (4)postbit_legacy
  • (4)postbit_onlinestatus
  • (4)postbit_wrapper
  • (4)showthread_bookmarksite
  • (7)showthread_similarthreadbit
  • (1)showthread_similarthreads
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper
  • (1)vbseo_linkbackmenu_entry 

Phrase Groups Available (6):
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files (39):
  • ./vbseo.php
  • ./env.php
  • ./vbseo/includes/functions_vbseo.php
  • ./vbseo/includes/functions_vbseo_pre.php
  • ./vbseo/includes/functions_vbseo_url.php
  • ./vbseo/includes/functions_vbseo_createurl.php
  • ./vbseo/includes/functions_vbseo_db.php
  • ./vbseo/includes/functions_vbseo_vb.php
  • ./vbseo/includes/functions_vbseo_seo.php
  • ./vbseo/includes/functions_vbseo_misc.php
  • ./vbseo/includes/functions_vbseo_crr.php
  • ./vbseo/includes/functions_vbseo_cache.php
  • ./vbseo/includes/functions_vbseo_hook.php
  • ./vbseo/includes/functions_vbseo_startup.php
  • ./includes/config.php
  • ./showthread.php
  • ./global.php
  • ./includes/class_bootstrap.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/functions.php
  • ./includes/class_friendly_url.php
  • ./includes/class_hook.php
  • ./includes/functions_cforum.php
  • ./includes/functions_facebook.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/class_bootstrap_framework.php
  • ./vb/vb.php
  • ./vb/phrase.php
  • ./packages/vbattach/attach.php
  • ./vb/types.php
  • ./vb/cache.php
  • ./vb/cache/db.php
  • ./vb/cache/observer/db.php
  • ./vb/cache/observer.php
  • ./includes/functions_notice.php 

Hooks Called (49):
  • init_startup
  • friendlyurl_resolve_class
  • database_pre_fetch_array
  • database_post_fetch_array
  • global_bootstrap_init_start
  • global_bootstrap_init_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • global_state_check
  • global_bootstrap_complete
  • global_start
  • style_fetch
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • friendlyurl_redirect_canonical
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • fetch_musername
  • cache_templates
  • template_register_var
  • parse_templates
  • notices_check_start
  • notices_noticebit
  • process_templates_complete
  • reputation_image
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • memberaction_dropdown
  • postbit_attachment
  • tag_fetchbit_complete
  • showthread_similarthread_query
  • showthread_similarthreadbit
  • forumrules
  • showthread_bookmarkbit
  • navbits
  • navbits_complete
  • showthread_complete


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1