VBEBookmarks.dll is a simple COM Add-in created by Jim Rech for the Microsoft Office 2000-2007 Visual
Basic Editor which lets you bookmark up to five locations in VBA projects for easy navigation among them.

Download the zip file with the dll


To register the DLL:

1: Unzip the dll anywhere on your machine.
2: Open a command prompt window

Windows XP :

Start>Programs>Accessories>Command Prompt



Change to the folder you've copied the DLL into with cd, I use a folder named Add-ins in C:\
Enter "cd C:\Add-ins" (without quotes) at the command prompt and press Enter.
Enter "REGSVR32 VBEBookmarks.dll" (without quotes) at the command prompt and press Enter.



If you do it correctly you will see this:



Close the command prompt window.


Windows Vista :

Start>All Programs>Accessories Make sure you start your Command Prompt with Administrator privileges.
Right click the Command Prompt shortcut and click Run as Administrator.




Change to the folder you've copied the DLL into with cd, I use a folder named Add-ins in C:\
Enter "cd C:\Add-ins" (without quotes) at the command prompt and press Enter.
Enter "REGSVR32 VBEBookmarks.dll" (without quotes) at the command prompt and press Enter.

Note: See the word Administrator in the header now



If you do it correctly you will see this:



Close the command prompt window.



To unregister the DLL:

If you want to remove the add-in use /u after REGSVR32



If you do it correctly you will see this:





How do I use the Add-in ?

When you start your Office application and switch to the Visual Basic Editor the
Bookmarks toolbar will appear automatically. If you don't like its location you can
move it wherever you want and the add-in will try to remember that location for the future.
Use Add-Ins, Add-In Manager to control whether the add-in starts up automatically and to
load and unload it manually.



The Bookmarks toolbar has five toolbuttons captioned "1" to "5"
and a sixth toolbutton captioned "R" to reset or free up used toolbuttons.
All toolbuttons are initially available and have the tooltip "Unused" when you mouseover them.

When you find a place in a module you want to bookmark simply click an unused toolbutton.
The toolbutton will appear "pressed" and its tooltip will change to the name of the parent
Office document/workbook, etc., module and line number.

To have a toolbutton that is already in use mark the current location instead hold the
Shift key down when you click it.

To return to this spot later simply click the same toolbutton.

To reset all toolbuttons (mark them unused) click the R button.


Tips and caveats:

-You can bookmark a userform as well as a code module.
-If a line(s) of code or any part of it is selected when you add a bookmark the add-in will try to
 restore the complete selection.
-If a module or userform is renamed the add-in will fail to find a bookmark.
-If a parent document is renamed (e.g., ABC.XLS->DEF.XLS) the add-in will generally fail to
 find a bookmark (but see below for an exception).
-When the add-in fails to find a bookmark it will mark the toolbutton "unused".
-A module bookmark is to a line number in the module, not to its contents. For example, line 40.
 If code is inserted or deleted above the bookmark line 40 will be returned to, even if the original
 text was moved or deleted.
-The bookmark feature requires that the parent document/workbook, etc., be saved before it will work.


Note re Renaming parent document:
In general if you rename a document, workbook, etc., the add-in will not be able to find a bookmark.
The exception is for "sequential renaming".
If the original document had a file name ending in at least one digit (eg., "File001.xls") and the
add-in fails to find it, it will try to find a document that matches the file spec "File*.xls".
If it is successful it will try to find a module with the right name. If that works it will go to the bookmark.
The reason for this is that some developers save sequentially numbered versions as they work to
maintain a history and to be able to "go back".
With this feature existing bookmarks will follow the renamed files.


Tip: For an easy way to register and unregister this or any DLLs in the future

If you often register and unregister dll files adding the options to the right click menu is very useful.
Note: This tip does not work in Vista if you have the User Account Control Enabled (Normal setting in Vista)
Under Vista you do not have Administrator privileges even if you are logged on as an Administrator
when the User Account Control (UAC) is Enabled.

Google for "register dll with right click" and you will find the information you need.