Windows 10: Multi User access to VB and VBA Program Settings Entries

Wnidows Ver: 20H2 Excel Ver: MSO 16.0.14026.20202 (32-Bit) I have an Excel Addin which is installed under a user account with Admin privileges ( for registration of a COM assembly) using inno Setup. The installer also sets some VB and VBA Program Settings entries. My problem is that when Excel is opened under a different user account the VB and VBA Settings keys are not available. Where can I set registry key entries (via innoSetup) whch can then be accessed from various user accounts.

:)

 

Multi User access to VB and VBA Program Settings Entries

Wnidows Ver: 20H2
Excel Ver: MSO 16.0.14026.20202 (32-Bit)

I have an Excel Addin which is installed under a user account with Admin privileges ( for registration of a COM assembly) using inno Setup. The installer also sets some VB and VBA Program Settings entries. My problem is that when Excel is opened under a different user account the VB and VBA Settings keys are not available. Where can I set registry key entries (via innoSetup) whch can then be accessed from various user accounts.

 

VBS Msgbox

Denis,

• I was too lazy to compute the size programmatically. And, it the 2005 version the message box always came up hidden, so I always used 0 for the top. It's also part of my OCD to be able to control everything.
• I personally don't need it to timeout. I used this in vbs files to ask to continue to the next step, skip the next step or cancel the vbs. BTW, I added the code back in but keep it assign it to 0.
• Sound was calling Windows Media Player: WshShell.Run "C:\Users\donast\desktop\sndrec32.lnk",7,false the lnk is a shortcut on my old desktop that had: "C:\Program Files (x86)\Windows Media Player\wmplayer.exe"
  "C:\Users\Public\Music\Wavefiles\Twilight.wav"
• Yes. The value is the number of the button in the order specified when calling it.
• Never really thought about it as all my VBS/VBA code is relatively simple and I add comments in the file as necessary to remind me what is going on. I don't usually have anyone to share my code.

FYI I use a VBS to call it. Here's a line from a test vbs I use to run your version:

choice=Wshshell.run("custommsgbox.vbs " & wscript.scriptname & " ""CopyFiles.vbs done. Continue with UnArchVista.vbs?"" ""White"" ""Black"" 40 ""Yes"" ""No"" ""Cancel""",1,true)

Copy it to a text editor to see all the spaces, etc. Took me a while back the to figure it out.

Don

 

Cannot write to Registry

It seems your assumption is incorrect. This key does not normally exist although your program assumes it does. You have these options:

• Inform the author of your program that his code must create the key unless it already exists.
• Create the key manually, using regedit.exe.
• Create the key by invoking this command:
  
  reg.exe add "HKCU\Software\VB and VBA Program settings"