M
macroman
Hello,
I wanted to create a macro to generate a unique number that can be used as a
"qute number".
My spreadsheet has a "now function" in it. My macro coverts this function
to a number format with four decimal points. So everytime I open the
spreadsheet it generates a new number.
I want the macro to work in the quote spreadsheet but be disabled once the
file has been saved to a new name.
I thought this would happen if I saved the macro in the "this workbook" but
when I save the file to a new name then close all workbooks and open the
saved file the quote number changes which does not help me.
I am using version 2003 with Office XP Professional
Is there a way to make this macro work on just the one spreadsheet?
thank you for your time
m
I wanted to create a macro to generate a unique number that can be used as a
"qute number".
My spreadsheet has a "now function" in it. My macro coverts this function
to a number format with four decimal points. So everytime I open the
spreadsheet it generates a new number.
I want the macro to work in the quote spreadsheet but be disabled once the
file has been saved to a new name.
I thought this would happen if I saved the macro in the "this workbook" but
when I save the file to a new name then close all workbooks and open the
saved file the quote number changes which does not help me.
I am using version 2003 with Office XP Professional
Is there a way to make this macro work on just the one spreadsheet?
thank you for your time
m