View Single Post
  #16   Report Post  
Posted to microsoft.public.excel.programming
Gary Keramidas Gary Keramidas is offline
external usenet poster
 
Posts: 2,494
Default Code to save workbook without macros

in my opinion, don't do it unless you need more than 65000 rows or 256 columns.
vba code runs slower, the interface sucks and some code isn't compatible.

that's my opinion.

--


Gary


"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