Excel macros

[SteveMcD]

Q1. How do I disable the screen display when running a macro so that th
screen doesn't flash and jump about? I am using Excel 97 in Window
98.

Q2. The last thing the macro does is prompt for a filename and save th
workbook as that name. Is there any way of saving the workbook withou
saving the macro with it

 

[Jan Karel Pieterse]

Hi SteveMcD,

Q1. How do I disable the screen display when running a macro so that the
screen doesn't flash and jump about? I am using Excel 97 in Windows
98.

Application.Screenupdating=False

And at the end

Application.Screenupdating=True

Q2. The last thing the macro does is prompt for a filename and save the
workbook as that name. Is there any way of saving the workbook without
saving the macro with it?

You could copy the worksheets to a new workbook (which does copy code
behind the sheets though):

Sub test()
Dim oNewbook As Workbook
ActiveWorkbook.Sheets.Copy
Set oNewbook = ActiveWorkbook
oNewbook.SaveAs "c:\data\test.xls"
oNewbook.Close False
Set oNewbook = Nothing
End Sub


Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com

 

[SteveMcD]

Many thanks Jan,

Both your solutions worked perfectly.

Steve