Hello everyone,

I'm using a workbook (.xlt) that someone else created. When I open the workbook for the first time, I get an input form that I fill in and then the workbook is saved as a normal .xls workbook.

The problem is that I then need to disable the macros so that the next time the workbook (.xls) is opened, the input form does not come up.

I disable the macros by changing the security setting to Very High. I then save the file and close it. The idea being that the next time the file is opened, the security setting is Very High, and the macros do not run. This works as long as I keep the Excel program open and only close the workbook. But if I close Excel completely and try opening the workbook again, then the macros run!

Is there another way of disabling macros? I take it that the security setting only applies while Excel is still open and the next time Excel is started, the security setting reverts back to the default setting?

Any help with how to disable macros would be much appreciated!

/Helen (using MS Excel 2003)