"As they have older
VB code, we cant save it under excel 2007 format"
What do you mean "older" VBA code? 2007 has the same VBA, with a few
more keywords. You could save under the 2007 format, xlsx if the
workbook being saved contains no code, xlsm if it does.
- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
774-275-0064
http://peltiertech.com/
On 5/5/2010 5:48 AM, seanpottinger wrote:
We have a particular issue with some spreadsheets and shrinking graphs on
each 'save as'. As they have older VB code, we cant save it under excel 2007
format and need to always save under 97-2003 format. This issue only started
occuring in the last month or so. It occurs on all PC's and for all sheets.
Is anybody aware of this issue or know if a hotfix is coming out?
Many thanks