Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello, I'm a beginner at using Excel macros, and after much cursing I was
finally able to get two macros to run on the same workbook. The one I'm having trouble with takes the data from a particular cell and uses it to rename the file before saving it. The problem is, both macros are still active when opening that new file. This is for invoices. The initial file is a blank invoice where I want the macros to run. The secondary file is saved as the customer's name. I do not want the macros to run on the secondary file. What can be done to auto-disable the macros on the new file? (These are both auto-run macros.) Thanks, Duane 'invoice number advance Private Sub Workbook_Open() Range("m3").Value = Range("m3").Value + 0.1 End Sub 'auto filename change Private Sub Workbook_BeforeClose(Cancel As Boolean) ThisFile = Range("D13").Value ActiveWorkbook.SaveAs Filename:=ThisFile End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
disable macros? | Excel Programming | |||
Disable macros | Excel Programming | |||
How to disable macros? | Excel Programming | |||
Suppress the Disable Macros / Enable Macros Dialog | Excel Programming | |||
en-/disable macros pop-up | Excel Programming |