Thanks, Harald, more questions for you...

  • Thread starter Thread starter pete
  • Start date Start date
P

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.
 
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.
Click to expand...

?? 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.
 
Back
Top