Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
'kay, so i'm a dummy.
have a workbook Template that i've added the following code to: Private Sub Workbook_Open() ans = InputBox("Name the new workbook") ActiveWorkbook.SaveAs Filename:="C:\Documents and Settings \FredFarnswithers\Desktop\" & ans & ".xls" End Sub works fine, however once saved, then reopened, the input box apears, etc. How do i get rid of the code, once the template is saved as a newly named workbook? Any help GRATEFULLY received!! Hugh |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Delete code | Excel Discussion (Misc queries) | |||
How to Delete VBS code via VBA | Excel Programming | |||
Code to delete a Line in a another code | Excel Programming | |||
VBA code delete code but ask for password and unlock VBA protection | Excel Programming | |||
VBA code to delete VBA code in another Workbook | Excel Programming |