+ Reply to Thread
Results 1 to 9 of 9

about registry keys

  1. #1
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,784

    about registry keys

    Hello

    What if I want to ask how to open a specific registry key window (say "edit Dword (32-bit) value" ) with vba.
    will this be a violation of Forum rule 11?
    Teach me Excel VBA

  2. #2
    Forum Expert
    Join Date
    02-14-2009
    Location
    .
    MS-Off Ver
    ................
    Posts
    2,840

    Re: about registry keys

    Seeing as there's about 50,000 DWORDS (Illustrative figure only, I've no idea) in the Registry, I doubt it but more to the point what you're proposing can be dangerous to your system. I note you mention 'open' a key, not 'read' or 'write' so make sure you understand the implications of what you are doing before you corrupt the Registry...

  3. #3
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,784

    Re: about registry keys

    Well I would need to actually change its value.It can be changed with RegWrite but that's not effective even if I restart the excel application and it returns to its previous state.but if we open the said window and change there in it remains stable and does not get restored to previous state.

  4. #4
    Forum Expert
    Join Date
    02-14-2009
    Location
    .
    MS-Off Ver
    ................
    Posts
    2,840

    Re: about registry keys

    So what, exactly, do you want to change?

  5. #5
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,784

    Re: about registry keys

    To change the value of "Edit DWORD (32-bit) value" of "AccessVBOM" from 0 to 1

  6. #6
    Forum Expert
    Join Date
    02-14-2009
    Location
    .
    MS-Off Ver
    ................
    Posts
    2,840

    Re: about registry keys

    Sorry - IMO that does fall under rule #11: "...breaking or bypassing any security measure"

    That key is set for a reason and is reset automatically by the application on startup.

    In any case, you're on a hiding to nothing. Setting the value does not affect the current setting (tested by me) and, as it's reset on start-up, this is a pointless exercise.
    Last edited by cytop; 04-29-2017 at 09:40 AM.

  7. #7
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,784

    Re: about registry keys

    Its ok......

  8. #8
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: about registry keys

    Isn't that the key for setting access to the visual basic object model?
    If posting code please use code tags, see here.

  9. #9
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,784

    Re: about registry keys

    Yes Sir Norie.It is

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Use API to edit registry keys to remove Add-In from Add-Ins List
    By mc84excel in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-13-2013, 12:00 AM
  2. Print Registry keys to a text file
    By djblois1 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 07-15-2011, 11:21 AM
  3. Excel 2007 : Need Help With A Registry
    By AgentDirtySanchez in forum Excel General
    Replies: 3
    Last Post: 06-26-2010, 09:32 PM
  4. [SOLVED] Registry Keys
    By EA in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-01-2006, 05:10 PM
  5. Change Registry in VBA
    By John Hutcins in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-24-2006, 06:50 PM
  6. Read Registry Keys (and possibly write)
    By Mike Iacovou in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-08-2006, 12:10 PM
  7. [SOLVED] How to use Alt keys + symbol keys to invoke a macro?
    By keithb in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-19-2005, 05:00 PM
  8. [SOLVED] Installing .xla add-in via the registry
    By RB Smissaert in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-26-2005, 05:19 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1