Feedback by UserVoice

KERATL

My feedback

  1. 1 vote
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)

      We’ll send you updates on this idea

      KERATL shared this idea  · 
    • 2 votes
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        Signed in as (Sign out)

        We’ll send you updates on this idea

        KERATL shared this idea  · 
      • 5 votes
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          Signed in as (Sign out)

          We’ll send you updates on this idea

          KERATL supported this idea  · 
        • 2 votes
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            Signed in as (Sign out)

            We’ll send you updates on this idea

            KERATL supported this idea  · 
          • 3 votes
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              Signed in as (Sign out)

              We’ll send you updates on this idea

              KERATL supported this idea  · 
            • 1 vote
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                Signed in as (Sign out)

                We’ll send you updates on this idea

                KERATL shared this idea  · 
              • 15 votes
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  Signed in as (Sign out)

                  We’ll send you updates on this idea

                  KERATL supported this idea  · 
                • 8 votes
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    Signed in as (Sign out)

                    We’ll send you updates on this idea

                    KERATL commented  · 

                    I apologize in advance for not being able to credit whoever originally wrote this, it's just something I copied into my personal.xlsb. Not used recently, but it worked the last time I needed it.

                    ' Macro that adds an extra command to the context menu of a cell
                    ' The command will be removed when you quit Excel.
                    Sub AddCommand()
                    Dim cbr As CommandBar
                    Dim cbb As CommandBarButton
                    Set cbr = CommandBars("Cell")
                    Set cbb = cbr.Controls.Add(Type:=msoControlButton, Temporary:=True)
                    With cbb
                    .Caption = "Don't Click This Option"
                    .Style = msoButtonCaption
                    .OnAction = "KilroyWasHere"
                    End With
                    End Sub

                    ' Macro that will be called from the custom command
                    Sub KilroyWasHere()
                    'ActiveWorkbook.Sheets.Add
                    MsgBox "I warned you...", , ""
                    End Sub

                  • 6 votes
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      Signed in as (Sign out)

                      We’ll send you updates on this idea

                      KERATL commented  · 

                      To extend the original suggestion- I also tried opening vbaproject.bin, but that isn't a directly readable file within the XLSM zip file using Noptepad++ (or presumably any text editor)

                      I realize that userforms may not lend themselves to plain text code, but I wonder if there is a way to expose the regular VBA code? It might be too much of a hassle to rewrite and re-integrate a plain text version of vbaproject.bin, but what if Excel just placed a second copy in the same folder, vbaproject.txt and store the raw code there? If a VBA project is locked/protected, that file could just be deleted.

                      This would give users a way (albeit inconvenient) to see code without moving the file out of unprotected view.

                      Just proposing this as an alternative that might be easier to code, but I'm still with the OP- it would be better for all users to allow viewing of (unlocked) VBA directly within protected view, only a small percent of these users would go poking around looking for a code text file.

                      KERATL commented  · 

                      What? we only have a limited number of votes?!? Yikes I better start being more selective (but I did upvote this one).

                      Absolutely agree with suggestion- This is a catch 22 for users. You either have to get out of protected mode to see the code to see if it was safe to unprotect.

                      It is possible, I suppose, that VBA would remain disabled and there will be a separate prompt for VBA after protected mode, but the casual end user has no idea if there are additional layers of protection at this stage ("protected view" doesn't really tell us what is protected, and what protection(s) we lose if we click ok)

                      KERATL supported this idea  · 
                    • 24 votes
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        Signed in as (Sign out)

                        We’ll send you updates on this idea

                        Thanks for the feedback. This is an interesting idea that we’ll consider for a future release. Please continue to vote on this feature idea.

                        Thanks,
                        Scott [MSFT]

                        KERATL commented  · 

                        Just came here to post this same suggestion.

                        Look at the site listed below (hope the URL survives this posting) for use case, demonstration of what a competitor is doing, and links to the lengths other people have gone to, to make this available in Excel. There are at least 3 Excel MVPs who have developed something similar over the years, but some of us can't install 3rd party add-ins, or the authors of the older solutions may not have the time to provide ongoing support.

                        This would make scatter charts 10x more useful.

                        URL: http://www.clearlyandsimply.com/clearly_and_simply/2016/08/customizable-tooltips-on-excel-charts.html

                        KERATL supported this idea  · 
                      • 2 votes
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          Signed in as (Sign out)

                          We’ll send you updates on this idea

                          KERATL supported this idea  · 
                        • 1 vote
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            Signed in as (Sign out)

                            We’ll send you updates on this idea

                            KERATL shared this idea  · 
                          • 1 vote
                            Sign in
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              Signed in as (Sign out)

                              We’ll send you updates on this idea

                              KERATL shared this idea  · 
                            • 6 votes
                              Sign in
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                              • facebook
                              • google
                                Password icon
                                Signed in as (Sign out)

                                We’ll send you updates on this idea

                                KERATL commented  · 

                                Right click the gray area of the ribbon, 'customize quick access toolbar', then select 'all commands' and add "paste and keep text only" and also "paste values" (which button is enabled will depend on the data in the clipboard).

                                Not the same as a hotkey combo, but it does give you direct access to those commands with just one click, regardless of what ribbon is active.

                                HTH

                              • 106 votes
                                Sign in
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  Signed in as (Sign out)

                                  We’ll send you updates on this idea

                                  Thanks for the suggestion. I think I’ve seen some related requests, I’ll look at merging them to make sure the votes properly reflect the ask. We’ll prioritize this into the execution pipe appropriately based on the number of votes.

                                  Cheers,
                                  John [MS XL]

                                  KERATL supported this idea  · 
                                • 3 votes
                                  Sign in
                                  Check!
                                  (thinking…)
                                  Reset
                                  or sign in with
                                  • facebook
                                  • google
                                    Password icon
                                    Signed in as (Sign out)

                                    We’ll send you updates on this idea

                                    KERATL supported this idea  · 
                                  • 2 votes
                                    Sign in
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      Signed in as (Sign out)

                                      We’ll send you updates on this idea

                                      KERATL supported this idea  · 
                                    • 1 vote
                                      Sign in
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        Signed in as (Sign out)

                                        We’ll send you updates on this idea

                                        KERATL commented  · 

                                        I agree that if a set of columns and/or rows is selected, it is intuitive to freeze *that* selection...

                                        Try this- create a new worksheet, select columns C and D, then hold the Control key and select rows 3 and 4. You now have a selection that doesn't go all the way to the top/left. What would be the intuitive behavior in this case? An error message saying there is an unselected range, or just auto-select everything above/left of the manual selection?

                                      • 1 vote
                                        Sign in
                                        Check!
                                        (thinking…)
                                        Reset
                                        or sign in with
                                        • facebook
                                        • google
                                          Password icon
                                          Signed in as (Sign out)

                                          We’ll send you updates on this idea

                                          KERATL shared this idea  · 
                                        • 59 votes
                                          Sign in
                                          Check!
                                          (thinking…)
                                          Reset
                                          or sign in with
                                          • facebook
                                          • google
                                            Password icon
                                            Signed in as (Sign out)

                                            We’ll send you updates on this idea

                                            Thanks for the feedback. This is an interesting idea. We’ll consider it in our next round of planning. Please continue to vote on this feature idea.

                                            Thanks,
                                            Scott [MSFT]

                                            KERATL supported this idea  · 
                                          ← Previous 1 3 4 5 6 7

                                          Feedback and Knowledge Base