Recent content by gcacinfotech

please see the matter and resolve when i have copied the code given in your guide the excel genrated gets saved as normal excel file after that a secure save dialouge box opens which user have to cancel to move further

Please resolve

i have included following code at module level since i need to generat excel sheets from two different subs Public xlspadlock As Object the code is otherwise working fine , the excel reports i am generating are getting saved as normal excel file. only problem is opening of un required secure...

I have included the definition at module level

Please look into the matter

the workbook i generated from vba code got saves as normal excel file successfully . however after that above window asking for secure save opens unnecessarily . Please resolve

[No message]

have done the trapping . the reports gets generated and get saved as normal save . however even after saving the workbook generated as normal excel files . a dialog box open for secure save code used by me is as follows fs = Application.GetSaveAsFilename(inm, " (*.xls), .xls") gs =...

i want to generate reports in xls format from my code . i want to save these files as normal excel files . i added following code given at point not 11.8 of xlspadlock user guide Dim xlspadlock As Object Set xlspadlock = Application.COMAddIns(“GXLS.GXLSPLock”).Object xlspadlock.setoption...

with xlspadlock will I be able to code sign applications using SHA1 or SHA2 code signing certificate since compilation screen has option for sha1 only does that mean sha2 cannot be used ? if any of them can be used which one is preferable

whether one should purchase SHA 1 code signing or SHA2 CODE signing to work with xls padlock

in that case that should happen even before the workbook is compiled . which I have already told that in the uncompiled workbook the un protected cells doesn’t get protected on pasting data where as in the exe when data is pasted unprotected cells get protected

please provide solution as i am stuck up

any solutions

yes the worksheet is protected by password , the password was filled in xls padlock at the time of compiling , also formula protection of xls padlock has not been used , since sheet does not contain any formulas , the top 2 rows has been protected by excel protection features , rest of the cells...