Personal.xlsb and Application window won't close and get in the way when opening

excelvbaisfun

excelvbaisfun

New member
Hi All,

When I open or close the workbook’s EXE file, it opens a blank window that says “Excel” in the window caption and another that has “Personal.xlsb” in it’s window’s caption. These cannot be hidden or closed manually. In fact, they get in the way of my actual excel sheet and I think the users are going to have a tough time realizing how to select the actual wb.


Pasted image1920×1040 6.4 KB

When I close the application, these 2 windows remain. I have to kill Excel using Task manager to make them go away.

Surely this isn’t by design with XLS Padlock. Does anyone know how to help me get rid of them?


blob.jpg667×316 46.3 KB

Thanks

Dan
 

Attachments

  • blob.png
    blob.png
    6.4 KB · Views: 0
  • blob.jpg
    blob.jpg
    46.3 KB · Views: 0
I created a solution that resolves this. If you’re having this problem, please put this macro in your Workbook_Open() procedure:
Code: 
Sub closeExtraWindows()
Dim awin As Window
For Each awin In Application.Windows
    If UCase(awin.Caption) = "PERSONAL.XLSB" Or Left(UCase(awin.Caption), 7) = "EXCEL -" Then
        If awin.Visible Then
            awin.Visible = False
        End If
    End If
    'Debug.Print awin.Visible
    'Debug.Print awin.Caption
Next awin

End Sub
I hope this helps some people and I hope it helps gdgsoft to help more people, because I’m very impressed with them and I want them to succeed!

Yours,
Dan
 
Thank you for your nice feedback 😃 and useful workaround.
In the incoming version 2.4 of XLS Padlock, we found a way to disable loading of Personal.xlsb so the problem won’t occur anymore.
 
I am testing the trial version, and have the same problem. Because of the customized ribbon made by a macro I check this under advanced options -> “do not disable access to XLStart user folder”. I get my ribbon, but there are several windows in the way, and I have to terminate the application with Task Manager.
 
My macro adds the ribbon into the file \Users\User\AppData\Local\Microsoft\Office\Excel.officeUI as explained in the link here:

stackoverflow.com

User Roi-Kyi Bryant

Stack Overflow | The World’s Largest Online Community for Developers
stackoverflow.com stackoverflow.com
 
Last edited:
This should be offered as a new feature in the next XLS Padlock version. Authors will be able to specify a custom Excel.officeUI file that will be used for the secure workbook.
 
Thanks for the follow-up! Glad that the most recent release fixed your problem, although we’ll still try to offer the option to have a customized Excel.officeUI 😉
 
Today, after deleting and reinstalling XLS Padlock, I have the problem again. Maybe it is my VBA code, but I have not idea what causes this problem.

Problem solved.
If Advanced options -> “do not disable access to XLStart user folder" is checked the problem occurs.
 
Last edited:
I still get the problem. Started a new test project.
With “do not disable access to XLStart user folder" ON - I get ribbon made by VBA, and 2 other windows opens, and I have to terminate the application with the Task Manager.

With “do not disable access to XLStart user folder" OFF - I do not get the ribbon by VBA before I change focus to some other application window in Windows, and then return focus to excel. Then everything is ok. But how to explain that to a customer?
 
Last edited:
This is only way I could find to refocus the excel window. This works, but Excel file withou XlsPadlock do not need this.

Sub Workbook_Open()
LoadCustomRibbon
UserForm.Show
End Sub

Sub UserForm_Activate()
Me.Hide
End Sub
 
You must log in or register to reply here.
Back
Top