Printing area of excel

XLS Padlock
1

I have an issue with the printing format of my excel.

The problem is that when I try to print with .EXE file created by xlspadlock the printing area of the original excel file has changed.
I am using Windows 8.1 64 bits and Office 2013 32 bits.

What happen is that the printing area is taking all the used cells of each sheet of the workbook instead of taking the defined printing area of the original excel file.

Therefore the clients will receive an excel with an incorrect area of printing.

2

In which language is your Excel?

3

In spanish.

4

Looks like a bug of Excel, you should try a VBA workaround to define the print area again when the workbook is opened.

5

Do you have any updates on this bug?

VBA workaround is not the best option for me.

6

The same problem here!
win 10 , excel 2010 x32 / x64 , Hebrew edition

I’ll be glad to know when there is a solution.

Cheers.

7

Which version of XLS Padlock? Did you enable or disable printing?

8

Both v2.5 and v3.0
"Allow print operations" box is marked

9

Try this option if it helps:

image
image499Ă—533 22.3 KB

Otherwise, you’ll have to set your printing area with VBA at workbook load: see vba - Set printing area In Excel 2013 using macro - Stack Overflow

10

I have the same issue with the German version (Windows 10, Office 365). In there another solution by now?
The option “Save workbook files against the language of VBA” did not work for me.
And the problem with setting the printing area via VBA is that I want to let the user change the printing area if he wants to. But this way, it would be overwritten every time he loads the workbook.
Furthermore, user defined printing areas are not saved.

11

Is this option enabled or not?

image
image801Ă—681 44.7 KB

12

It is not enabled. But I do not have any protected formulas anyway.

13

Do you think you can share your workbook file with us? Because in our tests, the printing area is kept.
If yes, you can use wetransfer.com to send us the link for download.

14

I cannot share the original workbook, but I tried a very simple sheet and got the same results, just defining a printing area, that does not match the used area, and leaving all the XLS Padlock settings on default (except for the 64bit-version).

I also have a workaround now, writing the size of the printing area into certain cells of the sheets and creating the printing areas with VBA when loading the workbook.

1 Like
15

An additional remark to my workaround: I also have to delete the printing areas before saving, otherwise I get the error again. Because the workbook may be saved without closing, I end up with a rather complicated and time expensive saving routine, as the workbook may well have 50 worksheets:

  1. Delete all printing areas
  2. Save file
  3. Create the printing areas again
    This also leads to the side issue, that the file is always changed after just saving it, but this is not a big problem for me.
1 Like
16

Hello !

Your support ticket system is not working - it gets stuck when submitting the message.

Here is my message from the support ticket:

Hello !

I really want to use and buy your software, but i have the following problem:

The print area is lost after converting an excel-sheet to exe.

This topic is discussed in your forum in a thread from 2015, title: Printing area of excel

I have the same issue - this is still not solved ?
I use the latest version of your software (trial), together with Excel 365 (german).

I also tried all hints given in that thread, without success.

Also i tried several excel sheets - including a nearly empty one, always with the same behaviour: the defined printing area is lost and the complete sheet is printed.

I dont want to use a vba workaround.

Hope you can help me, solving this problem.

Many thanks and greetings