vba:: Hide the Named Ranges in Excel

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
vba:: 스크랩 useless Select, Activate, ActiveCell, Set Range

vba:: 스크랩 useless Select, Activate, ActiveCell, Set Range

여기저기 관련글 스크랩  Using useless Select, Activate, ActiveCellUsing Select, Activate and ActiveCell in VBA can bring problems. And shows problems. In general, if you use the macro-recorder and record a macro, then you would see lots of Select, Activate, ActiveCell and etc. And it would work. Then why is it a problem?It is slow. All these .Activate and .Select actions take time.It is not necessa..

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

vba:: Copying Excel worksheet to a new workbook without leaving the old Excel reference (보호)

보호되어 있는 글입니다.

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

excel:: Index(Match) based on multiple columns (보호)

보호되어 있는 글입니다.

  • format_list_bulleted MS365.VBA.officeAddin
  • · 2022. 2. 13.
vba:: Error No description 에러발생시 숫자코드 설명

vba:: Error No description 에러발생시 숫자코드 설명

Error NumberDefault Error Message5Procedure call or argument is not valid6Overflow7Out of memory11Division by zero51Internal error52Bad file name or number53File not found55File already open76Path not found482Printer error  On Error Resume Next"Statement" If Err.Number 0 Then " statements" ''''''''''''''''''''' Imports SystemPubl..

  • format_list_bulleted MS365.VBA.officeAddin
  • · 2022. 1. 15.
  • textsms

vba:: Error Handler No Err 13 by type mismatch

vba함수는 엑셀의 특성으로 기본적으로 'As Varient'로 처리 되기 때문에 숫자 vs 글자 구분을 못할 때가 가끔 있음. 공학수식 관련에는 더욱 민감한데, vba함수의 변수에 잘못된 Type으로 입력하면 Error No 13이 발생함이럴 때를 위해 Err No. 13 (Type Mismatch) 은 따로 처리하는 것이 좋다. 원하지 않는 값을 입력하면 무시를 하고 넘어 갈 수도 있지만, 계산항목에는 잘못된 값이 들어가 있음에도 인지를 못할 때가 있다.   Public Function PropertyTP(ByVal output As String, ByVal Name1 As String) On Error GoTo ErrorHandler Dim Property_temp A..

  • format_list_bulleted MS365.VBA.officeAddin
  • · 2021. 8. 29.
  • textsms