Save Dialog Box


#1

How can I open the secure save dialog box via a macro to bypass clicking file and then save?

I need the exact same functionality as if a user was clicking file then save… only clicking a command button instead to open the secure save dialog box.

Is this possible?


#2

Invoke ThisWorkbook.Save VBA method without UI prompt.


#3

Hi Support,

If you invoke ThisWorkbook.Save VBA method without UI prompt to save the XLSC file, once you open the EXE and choose “Last Save”, will that open the file saved through ThisWorkbook.Save VBA?

Thanks,


#4

Yes, because ThisWorkbook.Save will be caught by XLS Padlock and trigger the usual Save Secure File dialog box asking the user to choose where to save the XLSC file. Then, the file is remembered in the history and users will be able to load it back.