I have an Excel '03 workbook which contains large amounts of macros
and VBA.

If an Excel '07 user opens the workbook, and saves it as a "Excel
Macro enabled workbook", then the VBA functionality continues to work
for them. However, often times they forget to save it in this fashion,
and save it only as an "Excel workbook". This disables the VBA
functionality.

It seems that once the VBA functionality is disbaled, there's no
getting it back. For example, if the Excel '07 user was to re-open
their "Excel workbook" and then re-save it as a "Excel Macro enabled
workbook", the VBA functionality does not return.

I was wondering whether any one could shed any light on how the VBA
fucntionality can be returned in the above scenario.

Thanks very much.

Hi Darren

Your code is gone if you save as xlsx
No way to get it back.

Reading the msgbox is the best thing a user can do when they try to save it as xlsx <g



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Darren" wrote in message ...
I have an Excel '03 workbook which contains large amounts of macros
and VBA.

If an Excel '07 user opens the workbook, and saves it as a "Excel
Macro enabled workbook", then the VBA functionality continues to work
for them. However, often times they forget to save it in this fashion,
and save it only as an "Excel workbook". This disables the VBA
functionality.

It seems that once the VBA functionality is disbaled, there's no
getting it back. For example, if the Excel '07 user was to re-open
their "Excel workbook" and then re-save it as a "Excel Macro enabled
workbook", the VBA functionality does not return.

I was wondering whether any one could shed any light on how the VBA
fucntionality can be returned in the above scenario.

Thanks very much.