Search results

Hi @gdgsupport and all, I was trying to debug an issue with my app so I enabled access to the VBE temporarily in order to step through. One problem I’ve never experienced before was that the app didn’t know that it was a protected app. When I tried this function, it was returning False even...

Anyone know how you’re supposed to ‘Register with Windows’? and if it’s costly?

Hi @gdgsupport, I had another client ask about this as they have a really cool gif and mp4 splash screen for their logo, they were wondering if there was any format of video that would work? If not gif, we could convert it if there’s a format that does work. Thanks again for such amazing...

It is indeed weird. I’ll likely make a workaround that copies or renames it after the file saveas and share it in the group. Perhaps we can have a tips section or if its useful enough it could go into documentation (up to you if course). Thanks for being awesome @gdgsupport! Dan

UPDATE So after hours and hours of playing with this, it seems that if I use ANY FILENAME that is not the same as whatever file they chose in the application.getsaveasfilename() dialog box, it worked. This lead me to believe that the application.getsaveasfilename() was ‘reserving’ that file...

Hi @gdgsupport and All , YOUR SOFTWARE IS AWESOME! I do need a bit of help please. I’m having trouble making a quick copy of a sheet and then saving that file. I used to use secure save files, but this app I don’t actually allow any saving, they always load the ‘Original’ version each time...

@gdgsupport Any thoughts why I have to compile to test these? Thanks for any insight. Thanks Dan

UPDATE After thorough testing, it seems this does work when compiled into a protected app, but it doesn’t work for me at design time (when in regular excel program). so for some reason this statement doesn’t apply for me (from the documentation): Anyone know why I can’t executed compiled VBA...

Hi @gdgsupport and ALL, When trying to play with the VBA compiler, I was following the steps outlined in the video here: and when I tried to run the =ten() function on a worksheet cell, it gave me this error: This error occurred in the VBA compiled code: “Access violation at address 221F6B92...

@gdgsupport, This is extremely valuable code and it worked for me! Thanks so much! You guys are incredible!!! Thanks Dan

Hi @gdgsupport (and All), I need help figuring out how to determine whether a user has Microsoft Excel installed as the 32bit Excel or the 64bit Excel, so the installer will go a different route in installing things. Can anyone help? I see there are system variables such as #IS64OS, but I’m...

Apologies for the delay. There’s an advanced setting I stumbled upon to calculate all formulas upon workbook opening, which recalculated these and the error went away. I suppose my setup was one of the perfect storms that this advanced setting was created for. Thanks Dan

So it seems the formulas DO work, but they show up as “ERROR” unless the user double clicks on them and then presses Enter. Why do you suppose this is happening? Then when I protect and open protected version: Then I must double click each formula… Thanks Dan

Hi @gdgsupport, I too have never used the protect formula feature until today, but was shocked when SUM doesn’t work. It’s okay that it doesn’t but do you have a cheat sheet of which functions won’t work? The pdf documentation only lists INDIRECT function and advises against data validation...

@PhuongM Brilliant!!

Cool! Sounds great, I’d love to take a look? Are you using OnTime method? Thanks Dan

Dude! Did I mention I love this software and it’s amazing support team. You freaking rock, @gdgsupport!!! Thanks Dan

Hi @gdgsupport, Is there a way to make a big gaudy flashy popup prior to people installing new version of an excel application (xls padlock application). Such as a messagebox or something to warn them: “WARNING: Did you perform a backup on your previous version of XYZ Application? If not...

Hi @gdgsupport, I like inverting those as well as your traditional “Overwrite” warning. Great ideas!!! I just don’t want to get beaten up if people keep losing their data! This sounds great, any idea when XLS Padlock 2.6 comes out? Thanks Dan

Hi @gdgsupport, I’ve had a few instances of people accidentally overriding a lot of data and losing all their excel database when opening the program. When people open my application and click ‘Original Workbook’ (instead of clicking ‘Last Save’ like they’re supposed to) and then they select...