A workbook is opened. User makes their alterations then
saves with a new name.
Before the save, code is removed from the ThisWorkbook
module (there was no other code, no other empty module).

When the newly named book is opened, the macro warning
is shown. If I save the workbook again, close, then reopen it,
then the warning appears to not display.

I believe this is normal behaviour?

Is there a way to achieve the removal of this 'redundant'
macro warning via code....so that when the user opens their
new workbook for the first time, there is no warning, or do
they have to go through the open/save/close/reopen
routine every time they create a new book, please?

Regards.


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.710 / Virus Database: 466 - Release Date: 23/06/2004