Excel Tips - Toggle The Screen Lock In Function

I would like to change the ScreenTips that appear when the cursor hovers over toolbar buttons (in Excel 2002), but I simply cannot find any mention, anywhere, of how to do this. (I would have thought that right-clicking on the icon in Customize would present an option, but it doesn't).

Any help would be appreciated,

Dear Forum

Is it possible to assign a screen tip to a cell?

Preferably dynamic

Thank you all for your time. It is greatly appreaciated

With KInd Regards


Paul Marks

Hi all,

I have a workbook that I have set up a lot of Hyperlinks in for navigation.
Without editing each individual hyperlink, is there an easy way that I can :

1. Change the Screen Tip text in all of them to read the same (this would be my compromise solution)

OR even better

2. Switch the Screen Tips off altogether (this would be my ideal solution)

Thanks in advance.

Doug

Hi,
I am using VBA to edit all of my Hyperlink Screen Tips, which works really well on my master worksheet. I am looking to edit all the other Worksheet Hyperlinks as well. This is what I have run on my Master Sheet;
Sub HLSCREENTIP()
Dim hl As Hyperlink
Dim rng As Range
Dim hlTip As String
'// Refine range if needed
Set rng = Sheets("SoCal Master").UsedRange
'// To apply to the active sheet
'// Set rng = ActiveSheet.UsedRange
'// Tip to replace current tips
hlTip = "Press For BoM"

For Each hl In rng.Hyperlinks
hl.ScreenTip = hlTip
Next hl
End Sub

I need to change the Screen Tip for the individual sheets, and would like to use code to run through all of them (over 200). I can edit the second Tip, however, i cant seem to fingure out how to get it to run on all sheets (Except Sheet 1, which is the Master Sheet). Can someone help me please?

Hey All,
Any chance there is an easy way to edit all Hyper link Screen Tips on a Worksheet @ once? I have a sheet with a 100 or so links, that i want a screen tip displayed. Is there an easy way?

thanks

Hi All,

Does anyone know if there is a way to add a screen tip to a macro button, so that when you hover over it with your mouse, it tells you something?

Thanks!

Hello,

i found some info on how to make an F11 shortcut in Excel, but i don't quite know how to implement it. Please help. Here is the link. Thanks

http://www.asap-utilities.com/blog/i...reen-with-f11/

I have the following code:

Code:

If DisplayFullScreen = False Then
    Application.DisplayFullScreen = True
ElseIf DisplayFullScreen = True Then
    Application.DisplayFullScreen = False
End If

which is linked to a key-board shortcut and attempts to turn full-screen mode on or off. The on portion works, but the off does not......... I do not think excel recognizes this if statement:

Code:

ElseIf DisplayFullScreen = True Then

Any ideas on how to fix it?

Thank you.

I have experienced a problem when adding ToggleButton, SpinButton and OptionButton controls on a Worksheet. The issue can be reproduced by

1) opening a blank sheet, opening the control toolbar and adding one each of ToggleButton, Spinbutton, and OptionButton.

2) Change resolution of the display (in my case from 1600x to 1024x), then click back and forth on the controls and a random cell. The control will either grow or shrink on each click.

I have tried to reset the control size via event trapping in VBA (set width and height of controls) - seemed initially to work, however the interior graphics of the controls continue to shrink.

Any help or advice would be greatly appreciated.

-- Peter

I have a menu screen in excel with macro buttons and text. can you make it
so the cursor cannot be moved around the screen.

I hvae tried protecting the sheet bit this seems to stop some of the macro
buttons from working.

many thanks
Duncan