Thanks, Harald, more questions for you...

[pete]

Your "Floating toolbar" works good. Now my question is
how to make it auto "open" when the file is opened, and
auto "close" when the file is closed?

Also, what is the code for ....
..... Range("current position").select ...???
where "current postition" = where the cell last rested.

Thanks for your great help.

 

[Harald Staff]

Hi Pete

Glad you like it. Assuming you didn't rename too much, rename here too if so. Place this
in the "ThisWorkbook" module:

Private Sub Workbook_Open()
Call CreateToolbar
End Sub

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Call KillIt(True)
End Sub

.... Range("current position").select ...???
where "current postition" = where the cell last rested.

?? Wherever you are, that is where your keyboard entries will land in, is ActiveCell. If
something moves the location then the previous location must be stored somewhere first if
you need to go back. Please provide some detail on what you are trying to make your code
do.