• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Hyperlink Screen Tip format

Hi there

I have an issue I am hoping you can help me fix.

I have a file where I am adding screentips to hyperlinks associated with pictures. The problem is that the hyperlinks sometimes appear next to the picture, and sometimes at the bottom of the screen where it is easy to miss them. Is there any way to have them displayed next to the picture every time?

Thanks in advance.
Colin
 
Apologies p45cal - I thought it may be a generic issue - the place the screen tip appears on the screen appears to be randomly either next to the picture or at the bottom of the screen. I am back in the office on Thursday and will upload a file then.

Thanks for the help.
C
 
HI there.

Attached a file where I have moved the offending sheet into a separate spreadsheet - the problem doesn't appear in this sheet for some reason, but I have pasted a screen dump from the main file which shows how the screentip appears randomly at the bottom of the screen. Realise this isn't ideal but hope this helps.

Thanks again.
Colin
 

Attachments

  • Sample of Screen tips.xlsx
    737.4 KB · Views: 8
The file doesn't seem to quite be a plain move of 'the offending sheet into a separate spreadsheet'; what's that big blue thing on the picture with "Milk Deck - Nielsen Data" on it and "v5.5" in the top left corner? It looks as if the positioning of the screentip is more related to that, than to any of the smaller pictures. Does the big blue thing have its own screentip and that's what we're seeing on the screendump? (Your screendump doesn't show the mouse so I don't know where it was hovering.)

I put a rectangle behind your pictures and gave it a screentip:

upload_2017-4-13_12-48-9.png

Note that you confused things by saying:
the hyperlinks sometimes appear next to the picture, and sometimes at the bottom of the screen where it is easy to miss them.
rather than screentips.
 
Last edited:
Hi There.

Apologies for the incorrect use of terminolgy.

The sheet I am using has a rectangle as a back ground - I was unable to upload the file including this as it seemed to make the file too big for uploading and so I cut it out. The rectangle has no hyperlink associated with it.

The screentip at the bottom of the screen dump is associated with one of the smaller pictures.

Hope this helps. If this is too random, don't worry - I do appreciate the help.

Thanks again.
Colin
 
Well, I'm all out of ideas at the moment; it's surprising that a rectangle could take up so much memory. Could you upload a file where this is happening to one of the free many file-sharing sites - you've probably already got one, (skydrive, google drive etc.)
 
No problem p45cal - appreciate the help. Leave it with me for the moment if that's okay as I have another challenge right now where I would really appreciate an elegant solution (and is perhaps a clearer issue to work through :)).

I have a worksheet which has a Year To Date (YTD) Flag for 2016 and 2017, and I need to sum only those columns which have that as a header - have attached a file.

Is there an easy way to do this?

Thanks again.
C
 

Attachments

  • YTD Calcs.xlsx
    379.4 KB · Views: 7
Yes, change the headers in cells BO4:BP4 to match the flags (put a Totals label above if you want), then use this formula in cell BO5:
=SUMIF($B$2:$BM$2,BO$4,$B5:$BM5)
copy down and across.
See attached.
 

Attachments

  • vbaExpress33987YTD Calcs.xlsx
    381.9 KB · Views: 6
Another option with layout heading set-up for 2016-2017, the calculation of YTD will be auto adjusted when new monthly data added.

1] " WeekNum" B1, formula copy across right to DB1 :

=COLUMNS($A1:A1)

2] "YTD Flag" B2, formula copy across right to DB2 :

=IF(MONTH(B3)<=(MONTH(TODAY())-1),"YTD "&YEAR(B3),"")

3] "w/e" B3, formula copy across right to DB3 :

=DATE(2016,1,2)-WEEKDAY(DATE(2016,1,3))+B1*7

4] "Total of YTD" DD4, formula copy across right to DE4, and all copy down :

=SUMIFS($B4:$DB4,$B$2:$DB$2,DD$3)

Regards
Bosco
 

Attachments

  • YTD Calcs.xlsx
    380.4 KB · Views: 4
…or you could automate your flag setting using a date in cell (say) BR2, see attachment.

To set a flag or not, I've used arithmetic to look at the day and month for your YTD for each year, but it might be more suitable/easier to use week numbers (WEEKNUM), of which there are several varieties, depending on which system of week numbering you want to use.
 

Attachments

  • vbaExpress33987YTD Calcs v2.xlsx
    387 KB · Views: 1
Last edited:
Back
Top