I have a very basic workbook created on my work pc, along with a set of very basic macros that look essentially like this:
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!
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.
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.