Search results

I am receiving a syntax error when trying to compile my macros. I do not understand the problem with this macro. I receive no errors within Excel, only within XLS Padlock. I get a similar error on all of the macros I have tried to compile. Please help.

I use Excel’s worksheet password protection to lock cells with formulas so that users do not accidentally delete formulas. Is it necessary to do this when using XLS Padlock? Does XLS Padlock lock the cells marked as “locked” on Excel’s format screen to prevent accidental deletion on the...

I am completely new to VBA and do not understand the instructions for the VBA compiler. I do not have any VBA on any of my worksheets, but I do have lots of recorded macros in different modules. To compile these, do I CUT them from their original module and paste them into the compiler, or do...

I got it while in Excel before compiling. I was trying to use the formula protection (right-click on the cell and choose formula protection). I am using V2018.2. I did have the sheet protected with a password through Excel and when I unprotected it, it worked. On some of the sheets I had to...

I am trying to select cells for formula protection and receiving the following error: XLS Padlock error: the add-in has fired an exception. OLE error 800A03EC I enabled the “Trust access to the VBA project object model”, as stated in the Help file, but this does not involve VBA, so it did not...

I sent an email, but thought I would ask the question here too. I have a spreadsheet with multiple pages, hundreds of formulas, and many, many drop-down menus that are handled by data validation in Excel. Will those drop-downs not work in a compiled workbook?