hi,
I have a excel sheet on which i perform some functions / calclations using a macro.
The problem is when this macro is run from a customized menu i created the date format changes from dd/mm/yyyy to mm/dd/yyyy although i am not touching these fields in the macro. Also tried setting the format just before saving the file (in the code itself).
Strange part is this works fine when run from the IDE (Editor provided by Excel)
Any suggestions Pls.
Cheers !!!
Niraj >
:O>
I have a excel sheet on which i perform some functions / calclations using a macro.
The problem is when this macro is run from a customized menu i created the date format changes from dd/mm/yyyy to mm/dd/yyyy although i am not touching these fields in the macro. Also tried setting the format just before saving the file (in the code itself).
Strange part is this works fine when run from the IDE (Editor provided by Excel)
Any suggestions Pls.
Cheers !!!
Niraj >
:O>
