| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Storing macros in one workbook
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Storing all macros in one workbook | Excel Programming | |||
| storing macros ? | Excel Discussion (Misc queries) | |||
| Storing Macros | Excel Programming | |||
| storing global macros | Excel Programming | |||
| Storing macros outside of Excel VB | Excel Programming | |||
Threaded Mode
