Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Programing for This Document Only
I've created macros for a document titled, "Balancing_Today" and I want those
macros only to apply to that workbook only, no others. I have the setting for the macro buttons set to Macro In This Workbook however the code for the macro appears in the other workbooks as well. How can I have those macros appear in just the one document. Thanks so much for your help. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Programing for This Document Only
On the second line of the module (just below Option Explicit) add Option Private Module -or- Prefix each Sub (macro) with Private ... Private Sub GoodStuff() 'code End Sub -- Jim Cone Portland, Oregon USA "SITCFanTN" wrote in message I've created macros for a document titled, "Balancing_Today" and I want those macros only to apply to that workbook only, no others. I have the setting for the macro buttons set to Macro In This Workbook however the code for the macro appears in the other workbooks as well. How can I have those macros appear in just the one document. Thanks so much for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Macro Programing | Excel Programming | |||
Macro programing in excell | Excel Programming | |||
excel 2007 macro/vb programing question | Excel Programming | |||
Macro Programing | New Users to Excel | |||
Macro programing | Excel Programming |