Search results

It won’t open my secure App IF there’s already an instance of Excel running (which is good), however, it will allow other workbooks to be opened once my app is already running. Is there a way to do both? Thanks Dan

Wow! That sounds awesome! Does XLS Padlock have validation as HTML Executable does? This is so exciting! Thanks Dan

Oh boy! That will really save me a lot of hassle. Currently, my applications run a lot of procedures in vba. This makes it cranky if you don’t save frequently. I added a Thisworkbook.Save command button, but each time it brings up the XLS padlock SaveAs dialog box. I would rather make my app...

Hi All + @gdgsupport, Is there a way to disable a license prior to the expiration date or days/uses allowed in the event of non-payment of subscription/dues or if someone breaks a contract or something? Just wondering. It would probably have to be some kind of thing that pings against the...

Hi @gdgsupport In order to disallow other workbooks prior to and after my app is running, whilst being able to manipulate (save,open, etc) other workbooks via the app in VBA, how would you do it? Also, are you suggesting I check or uncheck the highlighted checkbox? Thanks Dan

UPDATE: I tried checking the “Do not allow loading/saving other workbooks (even with VBA code)” checkbox under Security tab. Now my app won’t allow ANY other excel wb to open. This is good, sort of. However, the documentation says that if you put this in your code you can VBA save or create...

Hi All, I want to disable people from opening a workbook 1) before running my application and 2) during application running. Sometimes I need to open or save another wb using vba in the background and I understand I can do this using the SetOption helper. However, with my current settings, it...

Hi All + @gdgsupport, Does anyone know how to/if it’s possible yet to do animated GIF files for splash screen? That would be beyond sexy! Thanks Dan

Hi @gdgsupport I will make a new thread if you’d prefer - but kind of a follow up question to my saving woes - is there a way in VBA to save the current “xlsc” saved file. Sometimes I need to release some cached memory and clicking Save helps it to not crash before opening a big userform...

I think I figured it out. So I had the default “MAC Address” setting turned on for hardware locking, and now when people switch over to wi-fi at the company, they can no longer use the applications and I have to keep enabling them. So I turned off Mac Address and used the other 3. Thanks Dan

Hi All, It seems my users are asking me for activation keys again, even though nothing has happened since a week ago when I gave activation keys. I have my apps hardware locked with the 2 default settings. I have noticed that each time they ask for a key, their system ID is different. Wouldn’t...

Hi All, I’m looking for time savers with new versions of my Excel to EXE applications. I was able to create a batch file that builds 3 Paquet Builder files for me with a PAUSE command in between to ensure they are each successful. Now I’d like to do the same with XLS Padlock so I can click a...

Hi @gdgsupport, Thanks for all the thoughtful upgrades in ver 2.4 of XLS Padlock. Very exciting stuff!! I believe the “Open Workbook in Full screen” new setting in Advanced options doesn’t stay checked when you press close and/or Save. Thus, it does not open the excel applications in...

Good work! Thanks Dan

Thank you gdgsupport!! Awesome software!! Dan

Hi gdgsupport, That did help. I deselected “Lock VBA project” and still have the other VBA checkbox checked. Pasted image569×385 25.5 KB Will this be enough security for people to not be able to ever see my VBA? If so, I will leave it at that. I had also tried some error trapping methods and...

Hi All, I have the same problem. On my Padlocked wb, on the workbook_close event, I put a msgbox that asks if the user wants to print to pdf. If they answer no, it should just close, but instead it gives this error and crashes: Pasted image257×173 4.04 KB I’ve commented out the last part of...

Update: I found that the file opens fine IF I copied and pasted the file into a different directory that was not in PROGRAM FILES. Anyone know why Excel maybe can’t/shouldn’t be initiated from within PROGRAM FILES?? Otherwise, I’ll have to make the default directory something like...

Hi All, I’m using XLS Padlock and Paquet Builder. The EXE file works great - until it is compiled and installed using Paquet Builder on the same development pc. I have not tried installing it on another pc yet. I installed the EXE file to the program files directory and it appears in the folder...

I created a solution that resolves this. If you’re having this problem, please put this macro in your Workbook_Open() procedure: 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...