microsoft.public.excel.programming

Bob Flanagan

12/20/2006 1:24:00 PM

Try this:

Do a save as and save the file to the windows temporary folder. Use a
password when you save it so that the user can not re-open it from the
temporary location. Then, copy the sheets to a new workbook and save this
new workbook back over the old file. This removes all the modules which can
trigger a macro warning. You should also delete all macro buttons in the
new workbook.

Bob Flanagan
Macro Systems
144 Dewberry Drive
Hockessin, Delaware, U.S. 19707

Phone: 302-234-9857, cell 302-584-1771
http://www.a...
Productivity add-ins and downloadable books on VB macros for Excel

"Steve" <cannonwrighty@hotmail.com> wrote in message
news:1166617717.102681.196620@73g2000cwn.googlegroups.com...
> Hi All,
>
> I have an excel spreadsheet that runs a macro on opening and then
> within the workbook there are various buttons running further macros
> (i.e. to delete rows etc). After pressing the final button, i want all
> evidence of macros to be removed from the sheet. When the sheet is
> saved, closed and then reopened, i dont want the macro enable/disable
> to appear. Is this possible??
>
> I have found VBA code to remove all macro code, and when looking in
> Tools\macros, it appears they have all gone, but after saving, closing
> and re-opening, i still get the enable/disable popup, suggesting i
> still have macros within the sheet.
>
> Any quick responses will be greatly appreciated, on a tight deadline!!
>
> Many thanks
>