hi,
Want to change color of vba editor's font when i open my workbook
Tools>Options on the "Editor Format" tab
i want to change my editor selection color when i open my workbook
thank you
hi,
Want to change color of vba editor's font when i open my workbook
Tools>Options on the "Editor Format" tab
i want to change my editor selection color when i open my workbook
thank you
Use Code-Tags for showing your code :
Please mark your question Solved if there has been offered a solution that works fine for you
If You like solutions provided by anyone, feel free to add reputation using STAR *
Good evening HaroonSid
No. Well, not from within Excel at any rate.
You can do this by using RegEdit to change keys in the registry. Warning : Poking about indiscriminately in the registry can FUBAR your computer. Do not attempt this unless you are comfortable doing so.
The keys are :
- HKEY_CURRENT_USER\Software\Microsoft\VBA\7.0\Common\CodeForeColors
- HKEY_CURRENT_USER\Software\Microsoft\VBA\7.0\Common\CodeBackColors
If you are using a version of Office earlier than 2010, then replace 7.0 with 6.0. Valid values for these keys range between 0 (Auto) and 16.
HTH
DominicB
In Excel 2011, if one opens the VBEditor, under the Excel Menu, the Preferences option has an Editor Format tab.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks