View Single Post
  #10   Report Post  
Bob Phillips
 
Posts: n/a
Default

Thank you for that Dennis, it is appreciated.

Bob

"Dennis" wrote in message
...
Bob,

I really like your idea. One can see the information no matter where they
are on the worksheet.

Thanks so much for your time and knowledge.

Dennis

"Bob Phillips" wrote:

add this event procedure to ThisWorkbook

Private Sub App_WorkbookBeforeSave(ByVal Wb As Workbook, ByVal SaveAsUI

As
Boolean, Cancel As Boolean)
App_WindowActivate Wb, Windows(Wb.Name)
End Sub



--
HTH

Bob Phillips