get from Excel 2003 add-in to Excel 2007 add-in
On 26 Nov, 22:07, bill wrote:
All,
OK, I know I am having a mental block, but I cannot seem to transfer
my 2003 add-in to a 2007 add-in. I opened the AddIn.xls with Excel
2007 and saved it as a .xlsm. Then when I open the .xlsm and try to
get to the VBA editor by selecting View/Macros, I see all of my
macros, but they are "dimmed out". What am I missing here?
TIA,
Bill
Hi Bill,
Have you checked all your settings in the "Trust Centre"? The Trust
centre can be found by clicking on the circle in the top left, then
goto Excel Options, Trust Centre, Trust Centre Settings...
James
|