workbooks

[jenny_56]

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) how do you copy an entire workbook to a new workbook without having to copy each sheet one at a time

 

[John_McGhie_[MVP]]

Save As ... ?

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) how do you copy
an entire workbook to a new workbook without having to copy each sheet one at
a time

--

The email below is my business email -- Please do not email me about forum
matters unless I ask you to; or unless you intend to pay!

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410 | mailto:[email protected]

 

[CyberTaz]

If what you actually want is a second copy of the entire file why not just
use Finder? With the file closed, Control+Click the file icon in a Finder
window & select the 'Duplicate' command. Rename the new file to suit, then
drag it to the preferred folder if necessary.

Alternatively, Open the file, click the first tab in the workbook,
Shift-Click the last, then Control+Click one of the tabs & select 'Move or
Copy'. Open the 'To book:' list & select '(new book)', check the 'Create a
copy' box then 'OK'. Name & save the new file as usual.

HTH |:>)
Bob Jones
[MVP] Office:Mac