VBECustomColors icon indicating copy to clipboard operation
VBECustomColors copied to clipboard

64 Bit Office - Not working

Open Arrlin opened this issue 8 years ago • 3 comments

The VBE7.DLL is located in a different location (x86) > C:\Program Files (x86)\Common Files\microsoft shared\VBA\VBA7.1\VBE7.DLL (x64) > C:\Program Files\Microsoft Office\root\VFS\ProgramFilesCommonX64\Microsoft Shared\VBA\VBA7.1

Arrlin avatar Jun 24 '17 00:06 Arrlin

I don't have anything in the x86 path, only: (x64) > C:\Program Files\Microsoft Office\root\VFS\ProgramFilesCommonX64\Microsoft Shared\VBA\VBA7.1

Windows 11 and Office 365 (64 bit): latest updates

I have taken the steps to adjust the dll with hex editor but there is NO CHANGE to my VBA Editor environment. Hoping someone can point me in the right direction

cognociente avatar May 09 '22 07:05 cognociente

I have managed to get it working. For me, the registry changes were NOT optional; they were what seems to have made the whole process work.

cognociente avatar May 09 '22 07:05 cognociente

I have managed to get it working. For me, the registry changes were NOT optional; they were what seems to have made the whole process work.

Editing the DLL file changes the colors that are available as options within VBA. Changing the registry entry sets which colors are actually used from that list of available options.

If you don't make any changes to the registry (or manually change the settings yourself within VBA), then you won't see any changes in the colors you use.

techjp avatar Feb 02 '24 12:02 techjp