sheetsinnewworkbook

G

grt

hi,
i'm used the following line in a macro:
Application.SheetsInNewWorkbook = 1
the result is okay, meaning that I only get a workbook with
a single sheet added. However I would like to retrieve the
settings as they were before I run the macro.
tia
 
J

JE McGimpsey

grt said:
hi,
i'm used the following line in a macro:
Application.SheetsInNewWorkbook = 1
the result is okay, meaning that I only get a workbook with
a single sheet added. However I would like to retrieve the
settings as they were before I run the macro.
tia
Click to expand...

One way:

Dim nOldSheetsInNewWorkbook As Long
nOldSheetsInNewWorkbook = Application.SheetsInNewWorkbook
Application.SheetsInNewWorkbook = 1
'do stuff
Application.SheetsInNewWorkbook = nOldSheetsInNewWorkbook
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Save workbook without shapes 0
VBA word change keys 0
Drop down list control value in vba 2
Section and Page numbering 0
Converting URLs in comments to Markdown-formatted links 2
Making a macro only work on certain files 2
error while running macro, but not if stepping through lines. 3
Need a little help coping a sheet from one workbook to another. 2

Top