Hyperlinks - Automatically Display Comments

[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

 

[Chance1234]

which version of excel are you using >>?

Chance,

Filmmaker, taken gentleman and He tan e epi tas all change on monday

 

[Bru77]

It's Excel 2000.

Thanks

Brian

 

[Chance1234]

The code for adding a comment is below

    With Range("A1").Comment
        .Visible = False
        .Text Text:="Hello World"
    End With

To return the active cell , search in this forum for Target Cell. There are quite a few threads on teh topic

Chance,

Filmmaker, taken gentleman and He tan e epi tas

 

[Chance1234]

sorry that should be .visible = true

Chance,

Filmmaker, taken gentleman and He tan e epi tas