Open Macro in workbook, with calls to macros in personal.library

Rick Tidd 21 Reputation points
2023-02-01T16:27:31.3433333+00:00

Using this code:

I get the error message

Microsoft Visual Basic for Applications

Compile error:

Sub or Function not defined
The macros I am calling work fine on their own, but unlike the open macro, they exist in the Personal.library.

Any ideas on how to run this?

'opening macro  Private Sub Workbook_Open()

Private Sub Workbook_Open()

  Call UnProtectAllSheets
  
  Call Unhide_AD_and_AE
  
  
  End Sub
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,311 questions
0 comments No comments
{count} votes