HKEY_Current_users key for all users

Hi,

How Can I save a register key that must be stored in

[HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\excel\...]

For all Users that logon in this machine?

Regards
lnriveraAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

AnuroopsunddCommented:
can you provide more information about the key and settings. it will be helpful as their are some keys which are just for Current user and other can be set by Local Machine.
0
lnriveraAuthor Commented:
I have this issue  http://support.microsoft.com/kb/2570623   and I fix it with the manual solution (I attach a copy in the end of the email)

The question is that the solution only work for the current user, if any other user logon in this machine, I need to do again the the fix for each user.


"You can use the EnableOnLoad registry entry to configure how you want Excel to handle opening workbooks for the OFV. By default, the EnableOnLoad entry is not present in the Windows registry. To add the EnableOnLoad entry to the Windows registry, follow these steps:
1.Exit Excel.
2.Click Start, click Run, type regedit, and then click OK.
3.Locate and then click to select the following registry key:

HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\
4.After you select the key that is specified in step 3, point to New on the Edit menu, and then click Key.
5.Type Excel, and then press ENTER.
6.Select Excel, point to New on the Edit menu, and then click Key.
7.Type Security, and then press ENTER.
8.Select Security, point to New on the Edit menu, and then click Key.
9.Type FileValidation, and then press ENTER.
10.Select FileValidation, point to New on the Edit menu, and then click DWORD Value.
11.Type EnableOnLoad, and then press ENTER.
Note: The default value is 0 which disables the validation.
12.On the File menu, click Exit to quit Registry Editor."
0
AnuroopsunddCommented:
so as i understand you want a registry key as below
HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel\Security\FileVaidation\
and then DWORD Value ....Enable on Load with value 0

am i right?
0
10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

lnriveraAuthor Commented:
Exactly
0
AnuroopsunddCommented:
Function RegistryKaySet (subkey)
Const HKEY_USERs = &H80000003
strComputer = "."
Set oReg = GetObject("winmgmts:\\" & strComputer & "\root\default:StdRegProv")
       
strKeyPath = "SOFTWARE\Microsoft\Office\11.0"
oReg.CreateKey HKEY_USERS,subkey&"\"&strKeyPath
strKeyPath = "SOFTWARE\Microsoft\Office\11.0\Excel"
oReg.CreateKey HKEY_USERS,subkey&"\"&strKeyPath
strKeyPath = "SOFTWARE\Microsoft\Office\11.0\Excel\Security"
oReg.CreateKey HKEY_USERS,subkey&"\"&strKeyPath
strKeyPath = "SOFTWARE\Microsoft\Office\11.0\Excel\Security\FileValidation"
oReg.CreateKey HKEY_USERS,subkey&"\"&strKeyPath

strKeyPath = "SOFTWARE\Microsoft\Office\11.0\Excel\Security\FileValidation"
strValueName = "Enable on Load"
strValue= 0

oReg.SetDWordValue HKEY_USERS,subkey&"\"&strKeyPath,strValueName,strValue
End Function

    Const HKEY_LOCAL_MACHINE = &H80000002

    strComputer = "."
 
    Set oReg=GetObject("winmgmts:{impersonationLevel=impersonate}!\\" & _
        strComputer & "\root\default:StdRegProv")
 
    strKeyPath = "SOFTWARE\Microsoft\Windows NT\CurrentVersion\ProfileList\"
    oReg.EnumKey HKEY_LOCAL_MACHINE, strKeyPath, arrSubKeys
 
    For Each subkey In arrSubKeys
RegistryKaySet(subkey)
    Next
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
AnuroopsunddCommented:
Save above Code as file.Vbs and run it....
this will create entry for all the users profile under the HKEY_USERS.
so when the user login he should get the key already.

took some time to think for best solution... :)
0
lnriveraAuthor Commented:
Thanks, but I thionk that when a new user logon for the first time has the same problem, in case that a new user, this new account hasn't got the registry key
0
AnuroopsunddCommented:
entry is also made on HKLM so new user should also get the key  for new profile...
0
AnuroopsunddCommented:
I mean entry can be made to HKLM and .Default profile so that new profile also have this entry by default.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Legacy OS

From novice to tech pro — start learning today.