Storing macros in one workbook

G

Guest

I followed the instructions posted to Protect All Worksheets in a Workbook:

Sub Protect_All_Sheets()
Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets
ws.Protect password:="123"
Next ws
End Sub

This worked well. Now I need to add this to the Personal Macros Workbook so
that it is accessible for other workbooks. How can this be done?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem in adding macro to ribbon through Add-in 7
Hide Macro 3
Copy Worksheets To New Workbook 2
Protecting whole workbook 5
This used to work... 2
Sheet protection and cell fomat changes 4
Select not actualy selecting the cell 2
Placing the MsgBox "No ID found" statement in my code?? 12

Top