Thread: Code to save workbook without macros
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default Code to save workbook without macros
Hi Gord

Start downloading it now from MSDN

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Gord Dibben" <gorddibbATshawDOTca wrote in message ...
Cool!!

I just gotta get me one of those Excel 2007's<g


Gord

On Thu, 4 Sep 2008 02:17:21 +0200, "Ron de Bruin"
wrote:

Save the workbook as xlsx and the macro's are gone

Application.DisplayAlerts = False
'Save code
Application.DisplayAlerts = True

Reply With QuoteReply With Quote