Open and Save Dialog Boxes Crash Secure Workbook

S

scottogren

New member
I have a secure workbook that I have written VBA code to call the Windows dialog boxes to open and save files. This has worked for quite a while, until the latest update to Excel. Now, when I initiate the Open or Save dialog boxes, with either my code or the native excel buttons, the workbook crashes. I have three computers, two of which have the latest Office 365 updates, and one does not. The open and save dialog boxes crash the two computers with the latest update, and everything works as expected on the computer that does not have the update.

Is there a conflict with XLSPadlock and the latest update to Excel? Is there something I need to be doing to make this work?
 
Which update do you mean? Can you open your Office Account page and give us the exact version? And Windows version?
We always test the latest version of XLS Padlock with the latest Office official release (M365) and no crash reported.
For instance, can you also try this simple VBA code on the faulty computers?
Code: 
Sub Button29_Click()

    Dim cheminFichier As String

    cheminFichier = Application.GetOpenFilename( _
        Title:="Sélectionnez un fichier", _
        FileFilter:="Tous les fichiers (*.*), *.*")

    If cheminFichier <> "Faux" Then
        MsgBox "Fichier sélectionné : " & cheminFichier, vbInformation, "Fichier"
    Else
        MsgBox "Aucun fichier sélectionné.", vbExclamation, "Annulé"
    End If
End Sub

Is this option enabled or not in your project?
1748886222202.webp
 
Same here. And no problem.
Maybe you have some third-party program such as a shell extension that is invoked in open/save dialog boxes.

A handy tool to diagnose and resolve these issues is ShellExView by NirSoft.
  1. Download ShellExView:
    • Visit the official NirSoft page: ShellExView - Shell Extension Manager For Windows
    • Choose the appropriate version for your system (32-bit or 64-bit) and download the ZIP file.
    • Extract the contents to a folder of your choice.
  2. Run ShellExView:
    • Execute shexview.exe. No installation is required.
  3. Configure the View:
    • To focus on non-Microsoft extensions, go to the Options menu and select Hide All Microsoft Extensions. This helps in narrowing down potential culprits.
  4. Identify Problematic Extensions:
    • Sort the list by the Type column to group similar extensions.
    • Look for extensions related to context menus, as these often cause right-click delays.
  5. Disable Suspicious Extensions:
    • Select the extension(s) you suspect are causing issues.
    • Right-click and choose Disable Selected Items, or press F7.
  6. Test the Changes:
    • Restart Windows Explorer to apply changes:
      • Open Task Manager (Ctrl + Shift + Esc).
      • Find Windows Explorer in the list, right-click it, and select Restart.
      • Test your XLS Padlock workbook EXE file.
    • Check if the issue persists. If resolved, you've identified the problematic extension.
  7. Re-enable Extensions if Needed:
    • If disabling an extension doesn't help, you can re-enable it by selecting it and pressing F8.
 
I disabled every non-Microsoft extension and my workbook is still crashing when I try to open an existing file or save a new file. The Open and Save windows get stuck and eventually crash the workbook.
 
You did not answer to "Is this option enabled or not in your project?"
And have you tried a simple workbook with the code provided above?
 
This is the configuration I am using.

1749740558007.webp

I tried a few configurations and everything seems to crash when I click on an Open or Save button I have created.
 
I have tried several version of XLS Padlock. The screenshot above is in version 2025.0. I also get the same error when using version 2024.3 and 2024.1.
 
OK. Have you tried the simple VBA code mentioned above? We need to know whether this occurs with your current Excel workbook or any workbook.
 
Yes, I have that VBA code that activates when a button is clicked. I have three version of the open command in three different buttons and they all crash the secured workbook. All three work when in excel before compiling. Its only the compiled workbooks that crash.
 
scottogren said:
Yes, I have that VBA code that activates when a button is clicked. I have three version of the open command in three different buttons and they all crash the secured workbook. All three work when in excel before compiling. Its only the compiled workbooks that crash.
Click to expand...
Hi, I think I have the same problem. When opening a file dialog using VBA, Excel (the exe) hangs and then crashes (closes). Strangely it does sometimes work and does show the file dialog. Here is the code;
' Open file picker dialog
Dim fd As fileDialog
Set fd = Application.fileDialog(msoFileDialogFilePicker)

With fd
.InitialFileName = GetWorkbookPath & Application.PathSeparator
.AllowMultiSelect = False
.Title = "Please select the Config workbook for importing"
.Filters.Clear
.Filters.Add "Config Import", "*.xlsx"
'.Filters.Add "All Files", "*.*"

If .Show = True Then
m_strFileName = .SelectedItems(1)
Else
' User cancelled file selection
m_FileDialogCancelled = True
Exit Function
End If
End With

I am using the latest XLSpadlock version 25.0. And have "Allow secure save ticked". Using Excel 365, no virus software. Windows 10.
 
I don't know if knowing the build of Windows helps. Here is the build one of my computers is running that the secured workbooks crash when using the open and close buttons:

1750126711509.webp
 
We are focused on a workaround. If you agree, we can contact you when it's ready for testing by Direct Message on this forum.
 
You must log in or register to reply here.
Back
Top