Prev: closed workbook macro
Next: how to change this format?
From: Darren on 4 Jul 2008 03:10
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.

From: Ron de Bruin on 4 Jul 2008 13:03
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" <darren(a)ptpartners.net.au> wrote in message news:6fe385bd-8aa6-4eea-ae9a-fae9f440cc47(a)j33g2000pri.googlegroups.com...
>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.
>
 | 
Pages: 1
Prev: closed workbook macro
Next: how to change this format?