Recent content by barcop101

Have another customer with the same error as above… I saw this in the What’s new list in this past software update post (XLS Padlock 2.2 available - February 26th, 2016)… "Workaround for “Error setting data in registry - Failed to set data for ‘Data’.” What is the workaround? I can’t find it...

Tracked down the issue… please see email sent.

Sent you an email with link to an example workbook and a screen cast showing the crashes.

Sounds like compiling in 2019.1 using a template created in 2019 might be the issue. I was loading a template that had been created in 2019 into 2019.1 and the saved file was not working once compiled in 2019.1. Once I reverted back to 2019, loading the same template saving works again.

This was in my workbook compiled with 2019.1 and happened on both Excel 2013 and 365 versions. Deleting 2019.1 and recompiling the same workbook back in version 2019, everything in my workbook saves again with no issues.

No issues with your demo workbook. When saving on both the 2013 and 365 versions in the 2019.1 compiled workbook it did this weird thing too… when clicking “Save” from within the “File” tab, the secure save box opens then it freezes for a minute, the whole workbook closes and then a new blank...

Uninstalling 2019.1 and reinstalling 2019 and recompiling… workbook now saves.

I’ve duplicated the same issue on another computer running Excel 2013. Load the workbook compiled in the most recent version of padlock. When click the X in the top right corner, the “Do you want to save” box opens… click yes… the blue wheel spins for a bit and then the workbook closes without...

I have a user that I sent an updated workbook compiled in the newest padlock version. That replaced a workbook created in the previous padlock version. When they try to save a file in the new version, the save dialog box opens and when they go to enter a new file name the entire workbook closes...

Found a solution… this macro allows you to manually copy any data from any outside source, Word, Excel, etc. and click a button (with macro assigned to it) to paste into any cell in the compiled workbook. Tested using Excel 2013… if anyone uses it in a workbook compiled in different Excel...

If I copy data within the compiled workbook and then use the pastespecial macro it works fine, so it’s only not working when copying data from an outside source. Is the compiled workbook not seeing the copied data or treating the clipboard as being empty for some reason?

Using the current 2019 version and copying data from another Excel spreadsheet or text file. Copying from either source paste fine using the macro in the workbook before compiling.

I have a simple paste special macro assigned to a button image… Sub PasteSpecial() Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False End Sub So a user can copy data from an outside source and then select a cell in the workbook that will...

Is it possible to give a client a workbook that will stay in read only state? Example… I have a customer who purchases a full functional workbook and uses it for a year and creates a years worth of saved files. After the year I still want them to be able to open the saved files to view them...

Perfect… that fixed it. Thanks!