Search results

Yes. Both Workbook A & B are protected.

Have existing secure save Workbook A in padlocked application. Workbook A uses VBA to open Workbook B (using PLOpenSaveFile) which creates another instance of the application. This does not seem to provide a handle to the new application (and Workbook B) and allow access from Workbook A. I...

Ok, realised that GXLSPLock is not available until it the sheet is compiled. Also explains why the on error resume next is through the code snippets (which ignores these errors during dev in standard mode). All makes sense when you think about it!

Hi - Trying to set options around saving/loading files and need to use the GXLS.GXLSPLock, but getting an error whenever i reference it. ' This works Dim a As Object Set a = Application.COMAddIns("GXLSForm.GXLSFormula").Object ' this does not work Dim b As Object Set b =...