Excel Hyperlink query + macros

[Bru77]

Hi,

I'm new to macros and visual basic and am not sure about it at all. I have an excel workbook here with a building plan of a warehouse that contains, among other things, 20 network printers. Each printer on the floor is represented by a particular cell that contains a comment with info like printer name and type etc.

I have a second sheet in the workbook listing all the printers and all sorts of extra info. The name of each printer on this second sheet is hyperlinked back to the first sheet (main floor plan) to locate each printer when you click on the name. I would like however for the active cell to be a bit more prominent when you hyperlink to it i.e can I get the comment on the active cell to display automatically when you hyperlink to it.

I dont think this can be achieved without using the VB editor. I'm not experienced enough to figure out how to do it. Any Ideas?

Thanks

Brian

 

[AnotherHiggins]

Please post VBA questions in forum707, the VBA Visual Basic for Applications (Microsoft) Forum.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.