vba:: macro hiding - EvilClippy macro 4.0 (보호)

보호되어 있는 글입니다.

• format_list_bulleted MS365.VBA.officeAddin
• · 2022. 2. 20.

vba:: 32bit > 64bit 변환시 vba7, win64, PtrSafe, LongPtr (보호)

보호되어 있는 글입니다.

• format_list_bulleted MS365.VBA.officeAddin
• · 2022. 2. 19.

vba:: VBE DarkMode Theme VBA편집기 다크모드(보호)

보호되어 있는 글입니다.

• format_list_bulleted MS365.VBA.officeAddin
• · 2022. 2. 17.

vba:: Create a toggle button with code 누를때마다 글자변경

버튼을 누를 때 마다 표시되는 문구가 달라지는 매크로 버튼 하나로 단계적 절차를 표현할 때 활용가능 Sub Calculate() Application.ScreenUpdating = False With ActiveSheet.Buttons(Application.Caller) If .Caption = "Sum" Then Cells(12, 1).Value = "=R[-2]C+R[-1]C" Cells(12, 2).Value = "=R[-2]C+R[-1]C" Cells(12, 3).Value = "=R[-2]C+R[-1]C" Cells(9, 1).Value = .Caption .Caption = "subtract" ElseIf .Caption = "subtract" Then Cells(12, 1).Value = "..

• format_list_bulleted MS365.VBA.officeAddin
• · 2022. 2. 13.
• textsms

vba:: Searching with System.Collections.ArrayList

* 링크 못 찾음Thus, I was thinking that there should be a fast way to calculate the first few numbers with System.Collections.ArrayList as far as I have written about a helper to sort arrays and range sorter. So, as far as it can be obviously solved with a N^2 complexity algorithm it is quite easy to be done: Public Sub TaxiCabNumber() Dim a As Long Dim b As Long Dim ..

• format_list_bulleted MS365.VBA.officeAddin
• · 2022. 2. 13.
• textsms

vba:: Hide the Named Ranges in Excel

*스크랩 링크 못 찾음..   Yup! The named ranges are visible. You “SpecialPassword” can be seen by anyone. What should you do? Option 1 – use a database and proper hashing for storing of sensitive information. Option 2 – hide the names, from the Name-Manager, thus the worksheet would still refer them, but they will be not visible: This is the way to achieve it with VBA:  Sub UnhideAllNames() Dim tempNa..

• format_list_bulleted MS365.VBA.officeAddin
• · 2022. 2. 13.
• textsms