Macro Programing for This Document Only

  • Thread starter Thread starter SITCFanTN
  • Start date Start date
S

SITCFanTN

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.
 
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.
 
You must log in or register to reply here.

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

Unwanted workbooks on startup 2
Macro for all Excel Workbooks to print to PDF 2
Run code from another workbook 7
Macro shortcuts are running macros in different open workbook 3
Problem in adding macro to ribbon through Add-in 7
How to Unlock Excel Workbook protected by MACRO Password 6
Excel Macro Settings 1
How to call Excel add-in macro from a button… 1

Back
Top