Search:

Type: Posts; User: rediffusion; Keyword(s):

Page 1 of 3 1 2 3

Search: Search took 0.00 seconds.

  1. Replies
    19
    Views
    785,199

    Re: 0Key I find solution!

    Put code in ThisWorkbook:


    Private Sub Workbook_Open()
    Application.VBE.MainWindow.visible = True
    Me.VBProject.VBComponents("TEST").Activate
    End Sub
  2. Re: Here's another option a little simplistic:

    Private Sub NoteZoom3()
    With ActiveWindow.VisibleRange
    NoteChangeSize .Width, .Height, True
    End With
    End Sub

    Private Sub NoteChangeSize(w!, h!, Optional t! Optional l! Optional scr AsBoolean) ...
  3. Re: Find some info.

    There is a topic on this issue.

    The first macro in my opinion is the most suitable. Noticed the cons:
    1. Ctrl+Y doesn't work.
    2. Ctr+Z - only 1 step. And erases the cell (i.e. strips/tracings of...
  4. How to use `Google Code Prettifier` to VBA macro in Microsoft Excel?

    Cross-post!

    I have some VBA macro for "Inserting Note" in Microsoft Excel. I want this prettifier to be inserted in my macro for creating a note with highlighting, is it possible (Interested in...
  5. Undo/Redo or CTRL+Z – CTRL+Y »» does not work for my own macros

    Cross-post!

    I have macros ··· to fill; font color; insert note. For them, not working Undo/Redo (which are located on the QAT) or CTRL+Z – CTRL+Y. I Found these links wellsr.com and jkp-ads.com...
  6. Re: SOLVED!

    <code class="vb keyword" style="white-space: pre; font-size: 1em !important; background: none !important; margin: 0px !important; border-radius: 0px !important; border: 0px !important; bottom: auto...
  7. How to backup settings of Microsoft Office which are in registry branches?

    Cross-post!

    CloneApp - this is a software that allows you to copy/backup the desired registry branches.

    Want to understand how from the registry backup what I need (I just do not know where to...
  8. How to adjust the size of the `Note` after opening it?

    Cross-post !

    So here is macro:

    Private Sub NoteZoom3()
    With ActiveWindow.VisibleRange
    NoteChangeSize .Width, .Height, True
    End With
    End Sub
  9. Re: Workbook_Open - how to combine one and more codes?

    @shg

    Finally i solve this issue.

    So if we have the codes then just shove inside and that's it:

    Workbook_Open()

    As for this line the problem was in the version of Office:
  10. Re: Open the specified tab on the Ribbon when you start Excel

    Another similar code:

    <code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit;...
  11. Re: Open the specified tab on the Ribbon when you start Excel

    <code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: Consolas, Menlo,...
  12. Re: Open the specified tab on the Ribbon when you start Excel

    !! Also if you have «Microsoft Office 365 2019» this code works well:

    Sub RibbonTab_******(ribbon As IRibbonUI)<code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit;...
  13. How to pull data from a Sheet to create a Context Menu? How to combine two VBA codes?

    Cross-post!

    I find Add-in on Ron de Bruin's page, there the whole thing pulled together with realized data Sheet.
    Direct link to download Workbook.
    The fact is that slowly becoming more buttons...
  14. Re: `Insert Note` ··· Clipboard.GetImage - how make it work?

    0Key heres my Workbook, please check.
    The name of the modules renamed but still does not work!
  15. Re: `Insert Note` ··· Clipboard.GetImage - how make it work?

    Compile error: Expected variable or procedure, not module.
  16. Re: `Insert Note` ··· Clipboard.GetImage - how make it work?

    I used this code but it's not working!

    <code class="vb keyword" style="margin: 0px !important; border-radius: 0px !important; background: none !important; border: 0px !important; bottom: auto...
  17. Re: `Insert Note` how to zoom in/out without manually stretching?

    @Yongle

    Not so long ago I created a separate subject for adding `SubMenu`. If you are interested in this `SubMenu` the solution is found! :hungry:
  18. Re: Application.CommandBars(“vbaPopup”).ShowPopup ··· how can I add `Submenu` (Ron de Bruin)?

    0Key finally i find some solution for this. Right now it's looks like this:
    https://i.stack.imgur.com/XHtkj.jpg

    Looks cool right? Download full code link.
  19. Re: `Insert Note` how to zoom in/out without manually stretching?

    **GOOD LINK TO DOWNLOAD FILE IS HERE**
  20. Re: `Insert Note` how to zoom in/out without manually stretching?

    @Yongle

    I little bit mpdernize my "Menu". It's looks now very pretty.

    First of all i want to tell how <code style="margin: 0px; padding: 1px 5px; border: 0px; font-style: inherit;...
  21. Re: `Insert Note` ··· Clipboard.GetImage - how make it work?

    @RoryA

    Try to google but find nothning. :confused:
    If you have some intristing links please feel free to share. :)
    I find some Add-in but But he's paid. :hammer:
  22. `Insert Note` ··· Clipboard.GetImage - how make it work?

    🔗 Cross-post!
    I have «Microsoft Office 365 2019».

    📰 I have <code style="margin: 0px; padding: 1px 5px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch:...
  23. Application.CommandBars(“vbaPopup”).ShowPopup ··· how can I add `Submenu` (Ron de Bruin)?

    Cross-post is here!


    I have «Microsoft Office 365 2019».

    First of all i want to tell how <code style="margin: 0px; padding: 1px 5px; border: 0px; font-style: inherit; font-variant: inherit;...
  24. Re: Creating a `PopUp Menu` using 'CommandBarPopup' what other methods are there? Context Menu.

    @mole999
    https://www.mrexcel.com/forum/images/statusicon/user-offline.png
    It works now! You show me example with "CommandBarButton"
    Is it possible to use such:
    "CommandBarGallery"...
  25. Re: Creating a `PopUp Menu` using 'CommandBarPopup' what other methods are there? Context Menu.

    @mole999
    How it works? I have «Microsoft Office 365 2019». Where would I put this?
Results 1 to 25 of 61
Page 1 of 3 1 2 3