Search results

Thanks for what you do. If your company had to provide fixes separately for every past release when a bug was found, then the cost of deploying another update or maintaining the product would have to be increased substantially. Also, the resources required in fixing old releases could, in the...

Closed just about everything else open. It worked. Seemed to remember having this problem about a year and a half ago. Thanks.

Is anybody else running into a failure to sign with sha-256 and a successful signature with sha-1 on 2024.3? Did a 32/64 bit compile. See note (note: [12/25/2024 1:27:34 PM] The target file is not writeable because it is being used by another process.) Also, copied signature from properties...

Could you make a 16 byte user data field that would append to the computer code if mandatory. It wouldn’t be part of the unlock key process unless non-blank. That would preserve previous keys and allow the user data field to contain optional items when we generate the keys. In our case, we don’t...

I believe you need to change the .xplp files in the directory where you have your .xlsm file. For example, if your program name is IMFMain.xlsm, then you need to change the IMFMain.xplp and IMFMain.xlsm.xplp files to point to the different directory.

Hello Anna, I don’t know of a way to prevent the user from accessing the names manager. However, I hid the names with a hide/unhide routine which I run prior to compiling the workbook. I’ll share it with you…...

If you want to do more work, you can set yourself up with a CA and code sign your own programs. The client would have to install the CA as a Trusted Publisher in their system and you could be set for a long time.

I use the following in my compiled VBA: Application.PrintCommunication = False Application.ActiveSheet.PageSetup.FitToPagesWide = 1 Application.ActiveSheet.PageSetup.FitToPagesTall = False Application.PrintCommunication = True Application.ActiveSheet.ExportAsFixedFormat _ Type:=xlTypePDF, _...

Suggest you go to Security, Restrictions tab. Check on the following: Do you have the “Do not allow other instances of Excel when opening the protected workbook” checked? Do you have the “Only allow one instance of the protected workbook” checked?

I just saw this. Try checking the option “Allow loading/saving other workbooks through VBA SetOption helper” and see if that works. Please let us know.

Did you ever determine how to solve the problem?

Good idea. That’s better than imbedding it in the regular code. Thanks. Steve Glanstein +1 (808) 423-6766 [email protected]

Aloha, Doing well. On vacation in Argentina. I found that there was no problem starting the second time. It was always on the first time after I booted the computer. They really need to fix the timing or provide us with a wait parameter.

Is there any API available that could permit unlocking and relocking a spreadsheet or even a workbook using the original settings for lock/unlock? This would allow a work-around with some of the locked workspace and workbook restrictions. Currently the only way to do this with XLSpadlock is to...

Here’s the link https://we.tl/t-jMpMTOeArM Steve Glanstein +1 (808) 423-6766 [email protected] Notice: This e-mail message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is...

Sent. Two xlsm files. Two .exe files. Included configuration. I need an e-mail to send the passwords to. Steve Glanstein +1 (808) 423-6766 [email protected] Notice: This e-mail message is for the sole use of the intended recipient(s) and may contain confidential and privileged...

Hello, I was able to reproduce the problem in a simple manner with a workbook with no VBA code, edit ranges, several worksheets, etc. Need a secure way to send the workbook and compile parameters to you. Steve Glanstein +1 (808) 423-6766 [email protected] Notice: This e-mail message is for...

I’m on Version 2209, build 15629.20156. Should I change to another version? If so, need your assistance on what to try. Will try anything. Spent 3 days on this problem. Steve Glanstein +1 (808) 423-6766 [email protected]

Trying to get the Edit Ranges to work. It works if I don’t change a single edit range in the spreadsheet. One change and the compiled version fails to protect all ranges. Is there a limit on the number of worksheets in a workbook? Is there a limit on the number of edit ranges in a particular...

Hello, Excel 365 is up to date. It takes just over 30 seconds and the.exe spreadsheet also opens. You’ll notice the spreadsheet is successfully opened. The error seems superfluous or too short on the timing. The Task Manager shows the following (without the Outlook which came up after I put...