by default, Excel propose the format XLS without macro.
XLSX I think you meant. Yes this is most unfortunate; I wish MS had done
more work on this. I do not have a real solution for this problem however.
Maybe you can add a Before_Save macro that warns the user but I haven't
tried this out.
--
Jim
| Hello Jim,
|
| Thank you for your help.
|
| In fact, I have an application composed of several templates workbooks
| (XLTM). When the user selects a template, and save this workbook, by
| default, Excel propose the format XLS without macro. Most of users don't
pay
| attention to this and, thereafter, can no longer use the buttons and other
| tools programmed in their workbook
| Kind regards
| Charles
|
| "Jim Rech" <
[email protected]> a écrit dans le message de | (e-mail address removed)...
| >I don't know what you mean by 'forcing the registration'. If you want to
| >convert XLS workbooks to XLSM you're going to have to open them in Excel
| >2007 and do a Save As to the new format. Or use a macro that does that.
| >
| >
| > --
| > Jim
| > | >> Hello everyone!
| >>
| >> Is it possible, in Excel 2007, forcing the registration of certain
| >> specific workbooks in xls format with macros (XLSM)?
| >>
| >> If yes, how do I proceed?
| >>
| >> Thank you for your valuable assistance
| >>
| >> Charles
| >>
| >
| >
|
|