K
KJ
I have a particular easy macro I created that runs when I open a quote
workbook.
I have a separate workbook where I log all my quotes with quote numbers. On
my "Blank Quote" workbook I have a cell (out of the print area) that returns
the highest quote number listed from my "Log" file. I have another cell next
to it that takes that highest quote number and adds "1". Thus giving me my
next available quote number.
The macro I created copies that next available quote number, copies, and
pastes it as a value in the print area in my Quote number field. The idea was
that after I save my "Blank Quote" workbook as a quote number (ei Quote 150)
I could re-open my quote number 150 at a later date and always have the quote
number field return "150". Before I was just manually typing it.
I wasn't thinking ahead. Everytime I re-open quote "150", it runs the macro
again. If I've done other quotes since then, it changes the quote number to
whatever the highest number is again, plus 1.
Question: Can I save as, and not carry over this macro? Or is there another
way to accomplish my end goal?
Any help would be greatly appreciated!! FYI, I'm running 2007, but save most
everything in the 97-2000 compatible format so they can be used by others.
Also, creating this macro to run at the open workbook stage is the most
advanced vba thing I've ever done.
Thanks everybody!! Ken.
workbook.
I have a separate workbook where I log all my quotes with quote numbers. On
my "Blank Quote" workbook I have a cell (out of the print area) that returns
the highest quote number listed from my "Log" file. I have another cell next
to it that takes that highest quote number and adds "1". Thus giving me my
next available quote number.
The macro I created copies that next available quote number, copies, and
pastes it as a value in the print area in my Quote number field. The idea was
that after I save my "Blank Quote" workbook as a quote number (ei Quote 150)
I could re-open my quote number 150 at a later date and always have the quote
number field return "150". Before I was just manually typing it.
I wasn't thinking ahead. Everytime I re-open quote "150", it runs the macro
again. If I've done other quotes since then, it changes the quote number to
whatever the highest number is again, plus 1.
Question: Can I save as, and not carry over this macro? Or is there another
way to accomplish my end goal?
Any help would be greatly appreciated!! FYI, I'm running 2007, but save most
everything in the 97-2000 compatible format so they can be used by others.
Also, creating this macro to run at the open workbook stage is the most
advanced vba thing I've ever done.
Thanks everybody!! Ken.