Activate Questions
 

I have two questions:
I use a macro to find a row, and then use a hyperlink to go to the sheet I
want.
However, the sheet does not "Activate". I see the right sheet, but at the
bottom, the proper sheet is not highlighted. What do I need to add to
"activate" the sheet the hyperlink took me to?

In the same program, I call a macro in my consolidated workbook from the
workbook the data is in. The macro ends on the consolidated workbook, but the
display at the bottom is still showing the data workbook as being
highlighted. I want the consolidated workbook program to be highlighted.

Thanks!

Activate Questions
 

David,
Here is some code that I used on one of my projects. All three subs were
requred on each sheet that I wanted to use this userform. See if this helps
you out.

Private Sub Site_Data_Btn_Click()
Dim ActiveSheet As Worksheet

Worksheets("Attachment A").Activate
Load Site_Data_Frm
Site_Data_Frm.Show
End Sub
______________________________
Private Sub Worksheet_Activate()
Load Site_Data_Frm
End Sub
______________________________
Private Sub Worksheet_Deactivate()
Unload Site_Data_Frm
End Sub
_______________________________



"David" wrote:

I have two questions:
I use a macro to find a row, and then use a hyperlink to go to the sheet I
want.
However, the sheet does not "Activate". I see the right sheet, but at the
bottom, the proper sheet is not highlighted. What do I need to add to
"activate" the sheet the hyperlink took me to?

In the same program, I call a macro in my consolidated workbook from the
workbook the data is in. The macro ends on the consolidated workbook, but the
display at the bottom is still showing the data workbook as being
highlighted. I want the consolidated workbook program to be highlighted.

Thanks!

Activate Questions
 

I got the first issue worked out...now just looking how to activate the
workbook so I don't have to click the programs in the tray at the bottom to
switch.

"David" wrote:

I have two questions:
I use a macro to find a row, and then use a hyperlink to go to the sheet I
want.
However, the sheet does not "Activate". I see the right sheet, but at the
bottom, the proper sheet is not highlighted. What do I need to add to
"activate" the sheet the hyperlink took me to?

In the same program, I call a macro in my consolidated workbook from the
workbook the data is in. The macro ends on the consolidated workbook, but the
display at the bottom is still showing the data workbook as being
highlighted. I want the consolidated workbook program to be highlighted.

Thanks!