Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

scenarios macros

ResolvedVersion 2003

Subhash has attended:
Excel Intermediate course
Excel Advanced course

Scenarios, macros

how can you make sure these can be applied across spreadsheet files

RE: scenarios, macros

Hi Subhash

Thanks for your post - sorry for not getting back to you sooner

the answer to your question is unfortunatly you can only use scenarios that apply on a sheet by sheet basic and not over a workbook

If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn

Excel tip:

Closing Multiple Workbooks quickly

When you have several workbooks open in Excel and want to just close them all at once:

1) Hold down the SHIFT key before selecting the File menu.

2) Once in File menu release SHIFT key and select Close All option.

3) All your files will close. If files require saving Excel will ask if you want to save the changes.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.