Results 1 to 8 of 8

Thread: Secure Printing

  1. #1
    Join Date
    Mar 2010
    Posts
    27

    Unanswered: Secure Printing

    I have a very basic workbook created on my work pc, along with a set of very basic macros that look essentially like this:

    Sub PrintMe()
    Sheets("Sheet2").PrintOut
    Sheets("Sheet1").Select
    End Sub

    Not exactly super advanced stuff. We use secure printing at work, so anything printed from my computer is held until I go to the printer, select my staff number from the list, enter in my passcode, and then it prints everything I've sent to the printer.

    The macro works great on my pc, no problem at all. However, when I sent the workbook to a colleague.... the printing gets messed up. The first printout they do goes through as my staff number (but with my colleague's passcode). The subsequent prints work fine.

    The macros are the same, and the problem exists regardless of which order they choose (either of the 4 macros which are the same, but point to different sheets).

    Now... for the some reason, the first instance of any macro appears to be attaching itself to me as the author of the macro.

    I'm stumped. Any thoughts or possible solutions for me? Any help is greatly appreciated!

  2. #2
    Join Date
    Sep 2008
    Location
    London, UK
    Posts
    511
    Hi,

    When you send your workbook to your colleague, if your colleague tries to print a sheet by using the print button (ie. not using the macro), does the same problem occur on the first print?

  3. #3
    Join Date
    Mar 2010
    Posts
    27
    No, printing without the macro appears to work fine.

    This wouldn't be a big deal... but all the data is input on the first sheet, and the other sheets are populated by the data on the first. I don't really want people looking at the other sheets (or needing to look...), as the idea is to make it as quick and simple as possible to print the necessary document (sheet).

    I've actually got tabs hidden to prevent (most) people from even knowing the sheets are there.

  4. #4
    Join Date
    Sep 2008
    Location
    London, UK
    Posts
    511
    That's really strange. I'm not sure why that would be.
    When you send the file to your colleague, if he saves it before running the macro, does it work okay?

    One suggestion I have is to go to Tools > Options > Security Tab > Tick the "Remove personal information from file properties on save" checkbox. Save the file and then send it to your colleague. This should remove your information from the workbook.
    Last edited by Colin Legg; 12-21-10 at 19:14.

  5. #5
    Join Date
    Mar 2010
    Posts
    27
    Sorry the delay in the reply.

    Yes, the same problem still exists when my colleague saves the workbook to his computer first. We also tried saving the workbook on a network shared folder. Problem still persisted.

    I will try your option about the removing personal information checkbox, and get back to you after work tomorrow. That's a very good suggestion!

    Cheers for the help so far!

  6. #6
    Join Date
    Mar 2010
    Posts
    27
    Sorry again for the delay.

    I tried your option, but didn't correct the problem. I'm close to giving up... but it seems like such a foolish problem to have to give up on...

  7. #7
    Join Date
    Sep 2008
    Location
    London, UK
    Posts
    511
    Sorry, I don't know why the software would be picking up that information. I'd suggest contacting your IT floor support or the software vendor.

  8. #8
    Join Date
    Mar 2010
    Posts
    27
    I've tried the onsite IT support, and they were stumped as well. Saying exactly what you've said, that there's no reason it should be picking up the information.

    I'm ready to give up to be honest, which is a shame. /shrug.

    Thank you very much for your help though!

Posting Permissions

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