Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting a 'workbook' macro
Good day all, I wonder if anyone has come across this before? I have a 'private sub' macro which runs when a template is opened. Th utility of this is to assign an incremental Project ID to the templat each time it is opened. Obviously, the template is then saved under different name...as well as being saved as an .xls file. The problem: The private sub code is still there when the new name worksheet is opened and the increment still clicks up one numbe everytime the sheet is opened. I have been trying to write code t insert after the existing code in the .xlt file which will effectivel delete the code once the template has assigned a number. I am afraid I have not been able to do this, so any help would b greatly appreciated. Thank you -- chi ----------------------------------------------------------------------- chiv's Profile: http://www.excelforum.com/member.php...fo&userid=2340 View this thread: http://www.excelforum.com/showthread.php?threadid=37337 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
deleting workbook | New Users to Excel | |||
Deleting Workbook from others | Excel Worksheet Functions | |||
Finding and deleting macro in a workbook | Excel Discussion (Misc queries) | |||
Deleting workbook | Excel Programming | |||
Deleting workbook | Excel Programming |