Computer Based Training: …, Windows 95 & NT Basics/a1454501.iso/msoae/AE02.CTL

Text File | 1997-03-24 | 37.8 KB | 1,371 lines

*
SimScrn 2 1 14
MoveCtrl 1 493 410 0
*********************************
*          Course:   Advanced Excel 97
*          Unit:     Security and auditing        Unit No.:02
*          Topic:    Protecting worksheets        Topic No.: 1
****
eff.exe a02_101.gif 0 459 0 1 0 15 15 15
*                                   If you are a single user, you
isave 279 456 624 405 text1
textbox 279 456 624 405
showtext 0 0 2
pause 1 1 1 1 1 1 1 1
**
eff.exe a02_102a.gif 64 445 0 1 0 15 15 15
eff.exe a02_102b.gif 64 270 0 1 0 15 15 15
eff.exe a02_102c.gif 75 270 0 1 0 15 15 15
*                                   But if your workbooks can be a
isave 279 410 624 337 text2
growbox 279 410 624 337
showtext 0 0 4
pause 1 1 1 1 1 1 1 1
**
eff.exe a02_103a.gif 64 445 0 1 0 15 15 15
eff.exe a02_103b.gif 64 268 0 1 0 15 15 15
eff.exe a02_103c.gif 135 268 0 1 0 15 15 15
*                                   Protecting workbooks and works
isave 279 342 624 269 text3
growbox 279 342 624 269
showtext 0 0 4
pause 1 1 1 1 1 1 1 1
**
image memory text3 0 279 342
image memory text2 0 279 410
image memory text1 0 279 456
*
eff.exe a02_104a.gif 0 459 0 1 0 15 15 15
*                                   To protect a worksheet or work
isave 332 255 626 204 text1
textbox 332 255 626 204
showtext 0 0 2
pause 1 1 1 1 1 1 1 1
**
eff.exe a02_105a.gif 0 459 0 1 0 15 15 15
*                                   Excel allows you to choose to
isave 332 209 626 136 text2
growbox 332 209 626 136
showtext 0 0 4
pause 1 1 1 1 1 1 1 1
**
eff.exe a02_106a.gif 191 368 0 1 0 15 15 15
eff.exe a02_106b.gif 71 165 0 1 0 15 15 15
*                                   ≥ entire workbook
isave 332 141 626 102 text3
growbox 332 141 626 102
showtext 0 0 2
pause 1 1 1 1 1 1 1 1
**
eff.exe a02_107a.gif 0 459 0 1 0 15 15 15
*                                   ≥ shared workbook
isave 332 107 626 68 text4
growbox 332 107 626 68
showtext 0 0 2
pause 1 1 1 1 1 1 1 1
**
image memory text4 0 332 107
image memory text3 0 332 141
image memory text2 0 332 209
image memory text1 0 332 255
*
eff.exe a02_108a.gif 0 459 0 1 0 15 15 15
*                                   Before you protect a worksheet
isave 373 245 612 177 text1
textbox 373 245 612 177
showtext 0 0 3
pause 1 1 1 1 1 1 1 1
**
eff.exe a02_109a.gif 0 316 0 1 0 15 15 15
*                                   Suppose you want to allow user
isave 373 182 612 75 text2
growbox 373 182 612 75
showtext 0 0 6
pause 1 1 1 1 1 1 1 1
**
image memory text2 0 373 182
image memory text1 0 373 245
*
eff.exe a02_110a.gif 0 445 0 1 0 15 15 15
eff.exe a02_110b.gif 0 397 0 1 0 15 15 15
eff.exe a02_110c.gif 360 397 0 1 0 15 15 15
*                                   You begin by selecting the cel
isave 349 151 609 100 text1
textbox 349 151 609 100
showtext 0 0 2
pause 1 1 1 1 1 1 1 1
**
qcall AE02q 020101
eff.exe a02_111a.gif 38 451 0 1 0 15 15 15
eff.exe a02_111b.gif 151 451 0 1 0 15 15 15
*                                   Then you select Format - Cells
isave 349 105 609 66 text2
growbox 349 105 609 66
showtext 0 0 2
pause 1 1 1 1 1 1 1 1
**
*                                   Alternatively, you can right-c
notebox 351 262 603
**
image memory text2 0 349 105
image memory text1 0 349 151
*
eff.exe a02_113a.gif 26 451 0 1 0 15 15 15
*                                   You now choose the Protection
isave 342 324 628 290 text1
textbox 342 324 628 290
showtext 0 0 1
pause 1 1 1 1 1 1 1 1
**
qcall AE02q 020102
eff.exe a02_114a.gif 33 359 0 1 0 15 15 15
eff.exe a02_114b.gif 313 397 0 1 0 15 15 15
*                                   To allow users to change the s
isave 342 295 628 222 text2
growbox 342 295 628 222
showtext 0 0 4
pause 1 1 1 1 1 1 1 1
**
*                                   All the cells in a worksheet a
notebox 358 198 603
**
eff.exe a02_116a.gif 33 359 0 1 0 15 15 15
eff.exe a02_116b.gif 154 135 0 1 0 15 15 15
*                                   You now click OK
isave 342 227 628 188 text3
growbox 342 227 628 188
showtext 0 0 2
pause 1 1 1 1 1 1 1 1
**
image memory text3 0 342 227
image memory text2 0 342 295
image memory text1 0 342 324
*
SimScrn 2 2 14
MoveCtrl 1 493 410 0
*********************************
eff.exe a02_117.gif 0 459 0 1 0 15 15 15
*                                   Now choose Tools - Protec
isave 162 131 416 80 text1
textbox 162 131 416 80
showtext 0 0 2
pause 1 1 1 1 1 1 1 1
**
eff.exe a02_118a.gif 197 457 0 1 0 15 15 15
eff.exe a02_118b.gif 191 382 0 1 0 15 15 15
*                                   And then you select Protect sh
isave 162 85 416 46 text2
growbox 162 85 416 46
showtext 0 0 2
pause 1 1 1 1 1 1 1 1
**
image memory text2 0 162 85
image memory text1 0 162 131
*
eff.exe a02_119a.gif 2 457 0 1 0 15 15 15
*                                   The Protect Sheet dialog box a
isave 361 289 623 221 text1
textbox 361 289 623 221
showtext 0 0 3
pause 1 1 1 1 1 1 1 1
**
qcall AE02q 020103
eff.exe a02_120a.gif 411 429 0 1 0 15 15 15
eff.exe a02_120b.gif 2 376 0 1 0 15 15 15
*                                   You check the Contents checkbo
isave 361 226 623 136 text2
growbox 361 226 623 136
showtext 0 0 5
pause 1 1 1 1 1 1 1 1
**
eff.exe a02_121a.gif 237 234 0 1 0 15 15 15
*                                   ≥ viewing hidden rows or colum
isave 361 141 623 102 text3
growbox 361 141 623 102
showtext 0 0 2
pause 1 1 1 1 1 1 1 1
**
eff.exe a02_122a.gif 237 234 0 1 0 15 15 15
*                                   ≥ viewing hidden formula
isave 361 107 623 68 text4
growbox 361 107 623 68
showtext 0 0 2
pause 1 1 1 1 1 1 1 1
**
*                                   Checking the Contents checkbox
notebox 364 401 609
**
image memory text4 0 361 107
image memory text3 0 361 141
image memory text2 0 361 226
image memory text1 0 361 289
*
qcall AE02q 020104
eff.exe a02_124a.gif 2 348 0 1 0 15 15 15
eff.exe a02_124b.gif 217 243 0 1 0 15 15 15
*                                   When you check the Objects che
isave 284 188 607 120 text1
textbox 284 188 607 120
showtext 0 0 3
pause 1 1 1 1 1 1 1 1
**
eff.exe a02_125a.gif 42 333 0 1 0 15 15 15
*                                   You check the Scenarios checkb
isave 284 125 607 69 text2
growbox 284 125 607 69
showtext 0 0 3
pause 1 1 1 1 1 1 1 1
**
image memory text2 0 284 125
image memory text1 0 284 188
*
eff.exe a02_126a.gif 39 314 0 1 0 15 15 15
*                                   To protect the sheet further y
isave 362 222 611 171 text1
textbox 362 222 611 171
showtext 0 0 2
pause 1 1 1 1 1 1 1 1
**
eff.exe a02_127a.gif 243 244 0 1 0 15 15 15
*                                   Users need to enter this passw
isave 362 176 611 103 text2
growbox 362 176 611 103
showtext 0 0 4
pause 1 1 1 1 1 1 1 1
**
eff.exe a02_128a.gif 8 177 0 1 0 15 15 15
eff.exe a02_128b.gif 236 251 0 1 0 15 15 15
*                                   Now you click OK
isave 362 108 611 69 text3
growbox 362 108 611 69
showtext 0 0 2
pause 1 1 1 1 1 1 1 1
**
image memory text3 0 362 108
image memory text2 0 362 176
image memory text1 0 362 222
*
eff.exe a02_129a.gif 0 346 0 1 0 15 15 15
*                                   You confirm the password by ty
isave 407 156 606 105 text1
textbox 407 156 606 105
showtext 0 0 2
pause 1 1 1 1 1 1 1 1
**
eff.exe a02_130a.gif 0 367 0 1 0 15 15 15
*                                   And then you click OK
isave 407 110 606 71 text2
growbox 407 110 606 71
showtext 0 0 2
pause 1 1 1 1 1 1 1 1
**
image memory text2 0 407 110
image memory text1 0 407 156
*
eff.exe a02_131a.gif 0 449 0 1 0 15 15 15
eff.exe a02_131b.gif 0 430 0 1 0 15 15 15
*                                   Now users cannot change or ent
isave 320 452 624 401 text1
textbox 320 452 624 401
showtext 0 0 2
pause 1 1 1 1 1 1 1 1
**
eff.exe a02_132a.gif 2 449 0 1 0 15 15 15
eff.exe a02_132b.gif 487 431 0 1 0 15 15 15
eff.exe a02_132c.gif 0 279 0 1 0 15 15 15
*                                   For example, if you try to cha
isave 320 406 624 350 text2
growbox 320 406 624 350
showtext 0 0 3
pause 1 1 1 1 1 1 1 1
**
eff.exe a02_133a.gif 2 449 0 1 0 15 15 15
eff.exe a02_133b.gif 487 431 0 1 0 15 15 15
eff.exe a02_133c.gif 0 298 0 1 0 15 15 15
*                                   But Excel allows you to enter
isave 320 355 624 299 text3
growbox 320 355 624 299
showtext 0 0 3
pause 1 1 1 1 1 1 1 1
**
*                                   To move quickly between unlock
notebox 350 274 596
**
image memory text3 0 320 355
image memory text2 0 320 406
image memory text1 0 320 452
*
SimScrn 2 3 14
MoveCtrl 1 493 410 0
*********************************
eff.exe a02_135.gif 0 459 0 1 0 15 15 15
*                                   To remove protection from the
isave 326 152 610 101 text1
textbox 326 152 610 101
showtext 0 0 2
pause 1 1 1 1 1 1 1 1
**
eff.exe a02_136a.gif 197 457 0 1 0 15 15 15
eff.exe a02_136b.gif 191 382 0 1 0 15 15 15
*                                   And then you choose Unprotect
isave 326 106 610 67 text2
growbox 326 106 610 67
showtext 0 0 2
pause 1 1 1 1 1 1 1 1
**
image memory text2 0 326 106
image memory text1 0 326 152
*
qcall AE02q 020105
eff.exe a02_137a.gif 38 457 0 1 0 15 15 15
*                                   You enter the password you set
isave 371 176 618 125 text1
textbox 371 176 618 125
showtext 0 0 2
pause 1 1 1 1 1 1 1 1
**
eff.exe a02_138a.gif 176 336 0 1 0 15 15 15
eff.exe a02_138b.gif 369 336 0 1 0 15 15 15
*                                   And you click OK
isave 371 130 618 91 text2
growbox 371 130 618 91
showtext 0 0 2
pause 1 1 1 1 1 1 1 1
**
image memory text2 0 371 130
image memory text1 0 371 176
*
qcall AE02q 020106
eff.exe a02_139a.gif 2 431 0 1 0 15 15 15
eff.exe a02_139b.gif 485 432 0 1 0 15 15 15
*                                   The sheet is no longer protect
isave 256 135 491 67 text1
textbox 256 135 491 67
showtext 0 0 3
pause 1 1 1 1 1 1 1 1
**
image memory text1 0 256 135
*
eff.exe a02_140a.gif 34 381 0 1 0 15 15 15
eff.exe a02_140b.gif 34 296 0 1 0 15 15 15
eff.exe a02_140c.gif 362 267 0 1 0 15 15 15
*                                   Sometimes you need to prevent
isave 318 450 624 399 text1
textbox 318 450 624 399
showtext 0 0 2
pause 1 1 1 1 1 1 1 1
**
eff.exe a02_141a.gif 250 251 0 1 0 15 15 15
eff.exe a02_141b.gif 289 283 0 1 0 15 15 15
eff.exe a02_141c.gif 300 189 0 1 0 15 15 15
*                                   For example, any user can view
isave 318 404 624 331 text2
growbox 318 404 624 331
showtext 0 0 4
pause 1 1 1 1 1 1 1 1
**
image memory text2 0 318 404
image memory text1 0 318 450
*
eff.exe a02_142a.gif 15 431 0 1 0 15 15 15
eff.exe a02_142b.gif 558 432 0 1 0 15 15 15
eff.exe a02_142c.gif 2 296 0 1 0 15 15 15
*                                   Suppose you want to hide all t
isave 150 152 403 101 text1
textbox 150 152 403 101
showtext 0 0 2
pause 1 1 1 1 1 1 1 1
**
eff.exe a02_143.gif 0 459 0 1 0 15 15 15
*                                   You begin by selecting all the
isave 150 106 403 50 text2
growbox 150 106 403 50
showtext 0 0 3
pause 1 1 1 1 1 1 1 1
**
eff.exe a02_144a.gif 26 458 0 1 0 15 15 15
eff.exe a02_144b.gif 146 458 0 1 0 15 15 15
eff.exe a02_144c.gif 26 248 0 1 0 15 15 15
eff.exe a02_144d.gif 488 246 0 1 0 15 15 15
*                                   Then you select Format - Cells
isave 150 55 403 16 text3
growbox 150 55 403 16
showtext 0 0 2
pause 1 1 1 1 1 1 1 1
**
image memory text3 0 150 55
image memory text2 0 150 106
image memory text1 0 150 152
*
eff.exe a02_145a.gif 24 458 0 1 0 15 15 15
*                                   You check the Hidden checkbox
isave 366 352 605 318 text1
textbox 366 352 605 318
showtext 0 0 1
pause 1 1 1 1 1 1 1 1
**
eff.exe a02_146a.gif 105 369 0 1 0 15 15 15
eff.exe a02_146b.gif 155 174 0 1 0 15 15 15
*                                   And you click OK
isave 366 323 605 284 text2
growbox 366 323 605 284
showtext 0 0 2
pause 1 1 1 1 1 1 1 1
**
image memory text2 0 366 323
image memory text1 0 366 352
*
eff.exe a02_147a.gif 2 431 0 1 0 15 15 15
*                                   When the sheet is protected yo
isave 321 122 602 71 text1
textbox 321 122 602 71
showtext 0 0 2
pause 1 1 1 1 1 1 1 1
**
image memory text1 0 321 122
*
*
*          Topic:    Hands-on: Protecting worksheets        Topic No.: 2
****

********************************************************************
*          Hands-on:    Entering data
********************************************************************
*
***********************

simscrn 2 4 14
MoveCtrl 1 493 460 0 0
*
isave 341 387 619 319 text1
textbox 341 387 619 319
showtext 0 0 3
pause 1 1 1 1 1 1 1 1
**
isave 341 324 619 268 text2
growbox 341 324 619 268
showtext 0 0 3
pause 1 1 1 1 1 1 1 1
**
image memory text2 0 341 324
image memory text1 0 341 387
*
*
isave 338 387 616 319 text1
textbox 338 387 616 319
showtext 0 0 3
pause 1 1 1 1 1 1 1 1
*
image memory text1 0 338 387
**************************
*
*
exercise 01 2 120 70
task 01 0201 0 300 235 5 120 67 35 75
*
pause 1 1 1 1 1 1 1 1
*********************
*********************
*
*
simscrn 2 5 14
MoveCtrl 1 493 460 0
*
*
task 02 0202 0 300 320 7 120 67 35 75
*task 02 0202 143 300 495 7 120 67 35 75
*
pause 1 1 1 1 1 1 1 1
*********************
*********************
*
SimScrn 2 6 14
MoveCtrl 1 493 410 0
*********************************
eff.exe a02_301.gif 0 459 0 1 0 15 15 15
*                                   As well as protecting individu
isave 309 455 626 404 text1
textbox 309 455 626 404
showtext 0 0 2
pause 1 1 1 1 1 1 1 1
**
eff.exe a02_302a.gif 5 327 0 1 0 15 15 15
*                                   Suppose you want to use passwo
isave 309 409 626 336 text2
growbox 309 409 626 336
showtext 0 0 4
pause 1 1 1 1 1 1 1 1
**
image memory text2 0 309 409
image memory text1 0 309 455
*
eff.exe a02_303a.gif 5 457 0 1 0 15 15 15
*                                   You begin by selecting File -
isave 428 150 612 99 text1
textbox 428 150 612 99
showtext 0 0 2
pause 1 1 1 1 1 1 1 1
**
eff.exe a02a304a.gif 17 457 0 1 0 15 15 15
*
qcall AE02q 020201
eff.exe a02_304a.gif 504 341 0 1 0 15 15 15
eff.exe a02_304b.gif 617 345 0 1 0 15 15 15
eff.exe a02_304c.gif 397 285 0 1 0 15 15 15
*                                   Then you click Options
isave 428 104 612 65 text2
growbox 428 104 612 65
showtext 0 0 2
pause 1 1 1 1 1 1 1 1
**
image memory text2 0 428 104
image memory text1 0 428 150
*
qcall AE02q 020202
eff.exe a02_305a.gif 20 394 0 1 0 15 15 15
eff.exe a02_305b.gif 618 394 0 1 0 15 15 15
eff.exe a02_305c.gif 19 342 0 1 0 15 15 15
eff.exe a02_305d.gif 618 345 0 1 0 15 15 15
*                                   You can set a password that us
isave 400 236 609 168 text1
textbox 400 236 609 168
showtext 0 0 3
pause 1 1 1 1 1 1 1 1
**
eff.exe a02_306a.gif 154 321 0 1 0 15 15 15
*                                   And a password they must enter
isave 400 173 609 100 text2
growbox 400 173 609 100
showtext 0 0 4
pause 1 1 1 1 1 1 1 1
**
*                                   You check the Read-only recomm
notebox 405 402 597
**
eff.exe a02_308a.gif 179 395 0 1 0 15 15 15
eff.exe a02_308b.gif 410 395 0 1 0 15 15 15
*                                   Next you click OK
isave 400 105 609 66 text3
growbox 400 105 609 66
showtext 0 0 2
pause 1 1 1 1 1 1 1 1
**
image memory text3 0 400 105
image memory text2 0 400 173
image memory text1 0 400 236
*
eff.exe a02_309a.gif 22 395 0 1 0 15 15 15
*                                   You are prompted to confirm th
isave 6 453 265 402 text1
textbox 6 453 265 402
showtext 0 0 2
pause 1 1 1 1 1 1 1 1
**
eff.exe a02_310a.gif 299 376 0 1 0 15 15 15
eff.exe a02_310b.gif 416 286 0 1 0 15 15 15
*                                   You click OK
isave 6 407 265 368 text2
growbox 6 407 265 368
showtext 0 0 2
pause 1 1 1 1 1 1 1 1
**
eff.exe a02_311a.gif 19 423 0 1 0 15 15 15
*                                   Then you click Save
isave 6 373 265 334 text3
growbox 6 373 265 334
showtext 0 0 2
pause 1 1 1 1 1 1 1 1
**
eff.exe a02_312a.gif 20 423 0 1 0 15 15 15
eff.exe a02_312b.gif 106 272 0 1 0 15 15 15
*                                   And you click Yes to replace t
isave 6 339 265 283 text4
growbox 6 339 265 283
showtext 0 0 3
pause 1 1 1 1 1 1 1 1
**
image memory text4 0 6 339
image memory text3 0 6 373
image memory text2 0 6 407
image memory text1 0 6 453
*
eff.exe a02_313a.gif 5 458 0 1 0 15 15 15
*                                   You can now use the two passwo
isave 345 137 616 69 text1
textbox 345 137 616 69
showtext 0 0 3
pause 1 1 1 1 1 1 1 1
**
image memory text1 0 345 137
*
*
SimScrn 2 7 14
MoveCtrl 1 493 410 0
*********************************
eff.exe a02_314.gif 0 459 0 1 0 15 15 15
*                                   Excel allows you to protect a
isave 344 269 633 201 text1
textbox 344 269 633 201
showtext 0 0 3
pause 1 1 1 1 1 1 1 1
**
eff.exe a02_315a.gif 28 459 0 1 0 15 15 15
*                                   To protect a workbook, you sel
isave 344 206 633 150 text2
growbox 344 206 633 150
showtext 0 0 3
pause 1 1 1 1 1 1 1 1
**
footnote 1
image memory text2 0 344 206
image memory text1 0 344 269
*
eff.exe a02_316a.gif 27 459 0 1 0 15 15 15
*                                   You check the Structure checkb
isave 10 282 217 197 text1
textbox 10 282 217 197
showtext 0 0 4
pause 1 1 1 1 1 1 1 1
**
eff.exe a02_317a.gif 328 234 0 1 0 15 15 15
*                                   ≥ moving, deleting, hiding, or
isave 10 202 217 146 text2
growbox 10 202 217 146
showtext 0 0 3
pause 1 1 1 1 1 1 1 1
**
eff.exe a02_318a.gif 310 244 0 1 0 15 15 15
*                                   ≥ inserting worksheets or char
isave 10 151 217 95 text3
growbox 10 151 217 95
showtext 0 0 3
pause 1 1 1 1 1 1 1 1
**
eff.exe a02_319a.gif 310 249 0 1 0 15 15 15
*                                   ≥ moving or copying sheets to
isave 10 100 217 44 text4
growbox 10 100 217 44
showtext 0 0 3
pause 1 1 1 1 1 1 1 1
**
eff.exe a02_320a.gif 271 249 0 1 0 15 15 15
*                                   ≥ recording new macro
isave 10 49 217 10 text5
growbox 10 49 217 10
showtext 0 0 2
pause 1 1 1 1 1 1 1 1
**
*                                   To hide a worksheet you select
notebox 9 392 216
**
footnote 0
image memory text5 0 10 49
image memory text4 0 10 100
image memory text3 0 10 151
image memory text2 0 10 202
image memory text1 0 10 282
*
qcall AE02q 020203
eff.exe a02_322a.gif 33 351 0 1 0 15 15 15
eff.exe a02_322b.gif 33 217 0 1 0 15 15 15
eff.exe a02_322c.gif 236 216 0 1 0 15 15 15
*                                   Checking the Windows checkbox
isave 288 324 600 239 text1
textbox 288 324 600 239
showtext 0 0 4
pause 1 1 1 1 1 1 1 1
**
*                                   Users can still hide and unhid
notebox 300 401 579
**
image memory text1 0 288 324
*
qcall AE02q 020204
eff.exe a02_324a.gif 38 336 0 1 0 15 15 15
eff.exe a02_324b.gif 236 216 0 1 0 15 15 15
*                                   You can set a password that us
isave 285 225 542 140 text1
textbox 285 225 542 140
showtext 0 0 4
pause 1 1 1 1 1 1 1 1
**
eff.exe a02_325a.gif 93 187 0 1 0 15 15 15
eff.exe a02_325b.gif 195 187 0 1 0 15 15 15
eff.exe a02_325c.gif 2 154 0 1 0 15 15 15
*                                   Now you click OK
isave 285 145 542 106 text2
growbox 285 145 542 106
showtext 0 0 2
pause 1 1 1 1 1 1 1 1
**
image memory text2 0 285 145
image memory text1 0 285 225
*
eff.exe a02_326a.gif 2 429 0 1 0 15 15 15
eff.exe a02_326b.gif 2 364 0 1 0 15 15 15
*                                   The workbook is now protected
isave 365 217 600 183 text1
textbox 365 217 600 183
showtext 0 0 1
pause 1 1 1 1 1 1 1 1
**
*                                   Protecting a workbook does not
notebox 318 373 626
**
image memory text1 0 365 217
*

SimScrn 2 8 14
MoveCtrl 1 493 410 0
*********************************
eff.exe a02_328.gif 0 459 0 1 0 15 15 15
*

isave 8 305 220 186 text1
textbox 8 305 220 186
showtext 0 0 6
pause 1 1 1 1 1 1 1 1
**
eff.exe a02_329a.gif 11 459 0 1 0 15 15 15
eff.exe a02_329b.gif 588 459 0 1 0 15 15 15
*                                   To protect a shared workbook y
isave 8 191 220 101 text2
growbox 8 191 220 101
showtext 0 0 5
pause 1 1 1 1 1 1 1 1
**
image memory text2 0 8 191
image memory text1 0 8 305

*
eff.exe a02_330a.gif 20 459 0 1 0 15 15 15
*                                   You check the Sharing with Tra
isave 412 439 631 337 text1
textbox 412 439 631 337
showtext 0 0 5
pause 1 1 1 1 1 1 1 1
**
eff.exe a02_331a.gif 167 320 0 1 0 15 15 15
eff.exe a02_331b.gif 182 49 0 1 0 15 15 15
*                                   ≥ turn on the change history i
isave 412 342 631 286 text2
growbox 412 342 631 286
showtext 0 0 3
pause 1 1 1 1 1 1 1 1
**
eff.exe a02_332a.gif 190 276 0 1 0 15 15 15
eff.exe a02_332b.gif 190 36 0 1 0 15 15 15
*                                   ≥ prevent users turning off th
isave 412 291 631 235 text3
growbox 412 291 631 235
showtext 0 0 3
pause 1 1 1 1 1 1 1 1
**
qcall AE02q 020205
eff.exe a02_333a.gif 167 320 0 1 0 15 15 15
eff.exe a02_333b.gif 182 49 0 1 0 15 15 15
*                                   ≥ prevent users removing the w
isave 412 240 631 184 text4
growbox 412 240 631 184
showtext 0 0 3
pause 1 1 1 1 1 1 1 1
**
image memory text4 0 412 240
image memory text3 0 412 291
image memory text2 0 412 342
image memory text1 0 412 439
*
eff.exe a02_334a.gif 36 341 0 1 0 15 15 15
eff.exe a02_334b.gif 36 236 0 1 0 15 15 15
eff.exe a02_334c.gif 253 225 0 1 0 15 15 15
*                                   You can set a password that us
isave 332 456 613 388 text1
textbox 332 456 613 388
showtext 0 0 3
pause 1 1 1 1 1 1 1 1
**
*                                   You cannot set a password for
notebox 355 365 598
**
image memory text1 0 332 456
*
eff.exe a02_336a.gif 23 387 0 1 0 15 15 15
eff.exe a02_336b.gif 0 340 0 1 0 15 15 15
*                                   You confirm the password
isave 419 453 622 419 text1
textbox 419 453 622 419
showtext 0 0 1
pause 1 1 1 1 1 1 1 1
**
eff.exe a02_337a.gif 180 396 0 1 0 15 15 15
eff.exe a02_337b.gif 385 396 0 1 0 15 15 15
*                                   And then you click OK
isave 419 424 622 385 text2
growbox 419 424 622 385
showtext 0 0 2
pause 1 1 1 1 1 1 1 1
**
eff.exe a02_338a.gif 0 396 0 1 0 15 15 15
*                                   You click OK to continue
isave 419 390 622 351 text3
growbox 419 390 622 351
showtext 0 0 2
pause 1 1 1 1 1 1 1 1
**
image memory text3 0 419 390
image memory text2 0 419 424
image memory text1 0 419 453
*
eff.exe a02_339a.gif 11 456 0 1 0 15 15 15
eff.exe a02_339b.gif 588 456 0 1 0 15 15 15
eff.exe a02_339c.gif 37 337 0 1 0 15 15 15
*                                   The workbook is now shared and
isave 437 342 609 291 text1
textbox 437 342 609 291
showtext 0 0 2
pause 1 1 1 1 1 1 1 1
**
*                                   Protecting a shared workbook d
notebox 396 264 608
**
image memory text1 0 437 342
*
*          Topic:    Tracing dependents        Topic No.: 4
****

SimScrn 2 9 14
MoveCtrl 1 493 410 0
*********************************
eff.exe a02_401.gif 0 459 0 1 0 15 15 15
*                                   If you use workbooks that cont
isave 361 360 613 275 text1
textbox 361 360 613 275
showtext 0 0 4
pause 1 1 1 1 1 1 1 1
**
eff.exe a02_402a.gif 60 150 0 1 0 15 15 15
*                                   Excel provides auditing tools
isave 361 280 613 173 text2
growbox 361 280 613 173
showtext 0 0 6
pause 1 1 1 1 1 1 1 1
**
eff.exe a02_403a.gif 155 41 0 1 0 15 15 15
*                                   ≥ find the cells that provide
isave 361 178 613 122 text3
growbox 361 178 613 122
showtext 0 0 3
pause 1 1 1 1 1 1 1 1
**
eff.exe a02_404a.gif 108 150 0 1 0 15 15 15
eff.exe a02_404b.gif 281 191 0 1 0 15 15 15
*                                   ≥ identify the cause of an err
isave 361 127 613 88 text4
growbox 361 127 613 88
showtext 0 0 2
pause 1 1 1 1 1 1 1 1
**
image memory text4 0 361 127
image memory text3 0 361 178
image memory text2 0 361 280
image memory text1 0 361 360
*
eff.exe a02_405a.gif 197 457 0 1 0 15 15 15
eff.exe a02_405b.gif 60 111 0 1 0 15 15 15
*                                   Suppose you need to find out t
isave 349 434 623 366 text1
textbox 349 434 623 366
showtext 0 0 3
pause 1 1 1 1 1 1 1 1
**
eff.exe a02_406a.gif 189 459 0 1 0 15 15 15
eff.exe a02_406b.gif 128 271 0 1 0 15 15 15
*                                   First you need to display the
isave 349 371 623 298 text2
growbox 349 371 623 298
showtext 0 0 4
pause 1 1 1 1 1 1 1 1
**
image memory text2 0 349 371
image memory text1 0 349 434
*
eff.exe a02_407a.gif 2 459 0 1 0 15 15 15
*                                   You select the cell that you w
isave 301 152 609 118 text1
textbox 301 152 609 118
showtext 0 0 1
pause 1 1 1 1 1 1 1 1
**
qcall AE02q 020301
eff.exe a02_408a.gif 292 358 0 1 0 15 15 15
eff.exe a02_408b.gif 237 165 0 1 0 15 15 15
*                                   And you click the Trace Depend
isave 301 123 609 67 text2
growbox 301 123 609 67
showtext 0 0 3
pause 1 1 1 1 1 1 1 1
**
image memory text2 0 301 123
image memory text1 0 301 152
*
eff.exe a02_409a.gif 35 424 0 1 0 15 15 15
eff.exe a02_409b.gif 292 358 0 1 0 15 15 15
eff.exe a02_409c.gif 153 142 0 1 0 15 15 15
*                                   The two blue arrows point to t
isave 336 292 615 224 text1
textbox 336 292 615 224
showtext 0 0 3
pause 1 1 1 1 1 1 1 1
**
eff.exe a02_410a.gif 35 424 0 1 0 15 15 15
eff.exe a02_410b.gif 178 424 0 1 0 15 15 15
eff.exe a02_410c.gif 2 133 0 1 0 15 15 15
eff.exe a02_410d.gif 153 135 0 1 0 15 15 15
*                                   For example, the cell B13 cont
isave 336 229 615 173 text2
growbox 336 229 615 173
showtext 0 0 3
pause 1 1 1 1 1 1 1 1
**
image memory text2 0 336 229
image memory text1 0 336 292
*
eff.exe a02_411a.gif 2 424 0 1 0 15 15 15
eff.exe a02_411b.gif 178 424 0 1 0 15 15 15
eff.exe a02_411c.gif 2 133 0 1 0 15 15 15
eff.exe a02_411d.gif 153 135 0 1 0 15 15 15
*                                   To find out the cells to which
isave 38 326 261 241 text1
textbox 38 326 261 241
showtext 0 0 4
pause 1 1 1 1 1 1 1 1
**
eff.exe a02_412a.gif 292 360 0 1 0 15 15 15
eff.exe a02_412b.gif 168 166 0 1 0 15 15 15
*                                   As you can see, F12 doesn't pr
isave 38 246 261 190 text2
growbox 38 246 261 190
showtext 0 0 3
pause 1 1 1 1 1 1 1 1
**
eff.exe a02_413a.gif 159 108 0 1 0 15 15 15
eff.exe a02_413b.gif 429 166 0 1 0 15 15 15
*                                   But B13 provides data to F13
isave 38 195 261 156 text3
growbox 38 195 261 156
showtext 0 0 2
pause 1 1 1 1 1 1 1 1
**
image memory text3 0 38 195
image memory text2 0 38 246
image memory text1 0 38 326
*
qcall AE02q 020302
eff.exe a02_414a.gif 256 120 0 1 0 15 15 15
eff.exe a02_414b.gif 431 108 0 1 0 15 15 15
*                                   The dashed arrow pointing to t
isave 359 292 605 224 text1
textbox 359 292 605 224
showtext 0 0 3
pause 1 1 1 1 1 1 1 1
**
eff.exe a02_415a.gif 159 216 0 1 0 15 15 15
eff.exe a02_415b.gif 553 216 0 1 0 15 15 15
*                                   To view the dependent cells on
isave 359 229 605 156 text2
growbox 359 229 605 156
showtext 0 0 4
pause 1 1 1 1 1 1 1 1
**
eff.exe a02_416a.gif 128 276 0 1 0 15 15 15
*                                   When the pointer changes into
isave 359 161 605 105 text3
growbox 359 161 605 105
showtext 0 0 3
pause 1 1 1 1 1 1 1 1
**
image memory text3 0 359 161
image memory text2 0 359 229
image memory text1 0 359 292
*
eff.exe a02_417a.gif 411 429 0 1 0 15 15 15
eff.exe a02_417b.gif 27 371 0 1 0 15 15 15
*                                   The Go To dialog box displays
isave 373 282 616 231 text1
textbox 373 282 616 231
showtext 0 0 2
pause 1 1 1 1 1 1 1 1
**
*                                   If the reference is to a diffe
notebox 376 205 610
**
eff.exe a02_419a.gif 0 436 0 1 0 15 15 15
eff.exe a02_419b.gif 411 436 0 1 0 15 15 15
eff.exe a02_419c.gif 0 182 0 1 0 15 15 15
eff.exe a02_419d.gif 411 182 0 1 0 15 15 15
*                                   You double-click the reference
isave 373 236 616 197 text2
growbox 373 236 616 197
showtext 0 0 2
pause 1 1 1 1 1 1 1 1
**
image memory text2 0 373 236
image memory text1 0 373 282
*
eff.exe a02_420a.gif 0 436 0 1 0 15 15 15
*                                   The sheet that contains the de
isave 107 122 381 71 text1
textbox 107 122 381 71
showtext 0 0 2
pause 1 1 1 1 1 1 1 1
**
image memory text1 0 107 122
*
eff.exe a02_421a.gif 2 381 0 1 0 15 15 15
*                                   To remove the last set of depe
isave 35 360 280 275 text1
textbox 35 360 280 275
showtext 0 0 4
pause 1 1 1 1 1 1 1 1
**
eff.exe a02_422a.gif 317 366 0 1 0 15 15 15
eff.exe a02_422b.gif 168 150 0 1 0 15 15 15
*                                   To remove all the arrows from
isave 35 280 280 207 text2
growbox 35 280 280 207
showtext 0 0 4
pause 1 1 1 1 1 1 1 1
**
eff.exe a02_423a.gif 342 366 0 1 0 15 15 15
eff.exe a02_423b.gif 130 125 0 1 0 15 15 15
*                                   As you can see, all the arrows
isave 35 212 280 156 text3
growbox 35 212 280 156
showtext 0 0 3
pause 1 1 1 1 1 1 1 1
**
image memory text3 0 35 212
image memory text2 0 35 280
image memory text1 0 35 360
*
*          Topic:    Hands-on: Tracing dependents        Topic No.: 5
****
*
simscrn 2 10 14
MoveCtrl 1 493 460 0 0
*
*
isave 28 371 306 286 text1
textbox 28 371 306 286
showtext 0 0 4
pause 1 1 1 1 1 1 1 1
**
isave 28 291 306 201 text2
growbox 28 291 306 201
showtext 0 0 5
pause 1 1 1 1 1 1 1 1
**
image memory text2 0 28 291
image memory text1 0 28 371
*
exercise 02 1 120 70
task 03 0203 0 300 260 4 120 67 35 75
*
pause 1 1 1 1 1 1 1 1
*********************
*********************
*
*
SimScrn 2 11 14
MoveCtrl 1 493 410 0
*********************************
eff.exe a02_601.gif 0 459 0 1 0 15 15 15
*                                   Sometimes you need to find the
isave 387 202 611 134 text1
textbox 387 202 611 134
showtext 0 0 3
pause 1 1 1 1 1 1 1 1
**
eff.exe a02_602a.gif 35 426 0 1 0 15 15 15
eff.exe a02_602b.gif 70 206 0 1 0 15 15 15
*                                   Suppose you want to find the c
isave 387 139 611 66 text2
growbox 387 139 611 66
showtext 0 0 4
pause 1 1 1 1 1 1 1 1
**
image memory text2 0 387 139
image memory text1 0 387 202
*
eff.exe a02_603a.gif 0 459 0 1 0 15 15 15
*                                   You first select B12
isave 425 243 611 209 text1
textbox 425 243 611 209
showtext 0 0 1
pause 1 1 1 1 1 1 1 1
**
eff.exe a02a604a.gif 0 459 0 1 0 15 15 15
*
qcall AE02q 020401
eff.exe a02_604a.gif 238 400 0 1 0 15 15 15
*                                   Now you click the Trace Preced
isave 425 214 611 141 text2
growbox 425 214 611 141
showtext 0 0 4
pause 1 1 1 1 1 1 1 1
**
*                                   You display the Auditing Toolb
notebox 161 234 402
**
image memory text2 0 425 214
image memory text1 0 425 243
*
eff.exe a02_606a.gif 238 400 0 1 0 15 15 15
eff.exe a02_606b.gif 143 176 0 1 0 15 15 15
*                                   As you can see, the cells that
isave 309 198 605 130 text1
textbox 309 198 605 130
showtext 0 0 3
pause 1 1 1 1 1 1 1 1
**
*                                   The border indicates that the
notebox 355 313 542
**
eff.exe a02_608a.gif 143 281 0 1 0 15 15 15
*                                   If you click the Trace Precede
isave 309 135 605 62 text2
growbox 309 135 605 62
showtext 0 0 4
pause 1 1 1 1 1 1 1 1
**
image memory text2 0 309 135
image memory text1 0 309 198
*
eff.exe a02_609a.gif 143 401 0 1 0 15 15 15
eff.exe a02_609b.gif 374 368 0 1 0 15 15 15
*                                   You can remove the last set of
isave 359 243 601 158 text1
textbox 359 243 601 158
showtext 0 0 4
pause 1 1 1 1 1 1 1 1
**
image memory text1 0 359 243
*
*

SimScrn 2 12 14
MoveCtrl 1 493 410 0
*********************************
eff.exe a02_610.gif 0 459 0 1 0 15 15 15
*                                   Tracing precedents provides yo
isave 391 290 615 222 text1
textbox 391 290 615 222
showtext 0 0 3
pause 1 1 1 1 1 1 1 1
**
eff.exe a02_611a.gif 128 294 0 1 0 15 15 15
*                                   Suppose you trace the preceden
isave 391 227 615 171 text2
growbox 391 227 615 171
showtext 0 0 3
pause 1 1 1 1 1 1 1 1
**
eff.exe a02_612a.gif 143 323 0 1 0 15 15 15
*                                   As you can see, the data in B7
isave 391 176 615 120 text3
growbox 391 176 615 120
showtext 0 0 3
pause 1 1 1 1 1 1 1 1
**
eff.exe a02_613a.gif 146 323 0 1 0 15 15 15
*                                   But the cell should contain th
isave 391 125 615 69 text4
growbox 391 125 615 69
showtext 0 0 3
pause 1 1 1 1 1 1 1 1
**
image memory text4 0 391 125
image memory text3 0 391 176
image memory text2 0 391 227
image memory text1 0 391 290
*
qcall AE02q 020402
eff.exe a02_614a.gif 252 414 0 1 0 15 15 15
eff.exe a02_614b.gif 368 443 0 1 0 15 15 15
eff.exe a02_614c.gif 149 301 0 1 0 15 15 15
*                                   To correct the formula quickly
isave 298 186 625 135 text1
textbox 298 186 625 135
showtext 0 0 2
pause 1 1 1 1 1 1 1 1
**
eff.exe a02_615a.gif 2 443 0 1 0 15 15 15
eff.exe a02_615b.gif 558 432 0 1 0 15 15 15
eff.exe a02_615c.gif 2 16 0 1 0 15 15 15
eff.exe a02_615d.gif 558 16 0 1 0 15 15 15
*                                   The formula now refers to the
isave 298 140 625 101 text2
growbox 298 140 625 101
showtext 0 0 2
pause 1 1 1 1 1 1 1 1
**
eff.exe a02_616a.gif 3 431 0 1 0 15 15 15
eff.exe a02_616b.gif 369 432 0 1 0 15 15 15
eff.exe a02_616c.gif 2 294 0 1 0 15 15 15
eff.exe a02_616d.gif 369 323 0 1 0 15 15 15
*                                   You press Enter to confirm the
isave 298 106 625 67 text3
growbox 298 106 625 67
showtext 0 0 2
pause 1 1 1 1 1 1 1 1
**
image memory text3 0 298 106
image memory text2 0 298 140
image memory text1 0 298 186
*
eff.exe a02_617a.gif 2 379 0 1 0 15 15 15
eff.exe a02_617b.gif 146 427 0 1 0 15 15 15
eff.exe a02_617c.gif 104 115 0 1 0 15 15 15
*                                   If you trace the precedents of
isave 112 131 351 63 text1
textbox 112 131 351 63
showtext 0 0 3
pause 1 1 1 1 1 1 1 1
**
image memory text1 0 112 131
*

SimScrn 2 13 14
MoveCtrl 1 493 410 0
*********************************
eff.exe a02_618.gif 0 459 0 1 0 15 15 15
*                                   You can use the Trace Error bu
isave 3 453 281 385 text1
textbox 3 453 281 385
showtext 0 0 3
pause 1 1 1 1 1 1 1 1
**
footnote 2
eff.exe a02_619a.gif 484 363 0 1 0 15 15 15
eff.exe a02_619b.gif 148 232 0 1 0 15 15 15
eff.exe a02_619c.gif 421 192 0 1 0 15 15 15
*                                   Suppose another user has edite
isave 3 390 281 317 text2
growbox 3 390 281 317
showtext 0 0 4
pause 1 1 1 1 1 1 1 1
**
image memory text2 0 3 390
image memory text1 0 3 453
*
eff.exe a02_620a.gif 2 427 0 1 0 15 15 15
eff.exe a02_620b.gif 371 363 0 1 0 15 15 15
eff.exe a02_620c.gif 2 110 0 1 0 15 15 15
eff.exe a02_620d.gif 421 109 0 1 0 15 15 15
*                                   To locate the cause of the err
isave 291 193 591 125 text1
textbox 291 193 591 125
showtext 0 0 3
pause 1 1 1 1 1 1 1 1
**
image memory text1 0 291 193
*
eff.exe a02_621a.gif 2 381 0 1 0 15 15 15
eff.exe a02_621b.gif 2 363 0 1 0 15 15 15
eff.exe a02_621c.gif 371 363 0 1 0 15 15 15
*                                   You can now see the source of
isave 336 285 626 251 text1
textbox 336 285 626 251
showtext 0 0 1
pause 1 1 1 1 1 1 1 1
**
qcall AE02q 020403
eff.exe a02_622a.gif 143 228 0 1 0 15 15 15
eff.exe a02_622b.gif 142 143 0 1 0 15 15 15
*                                   The red arrow points from the
isave 336 256 626 183 text2
growbox 336 256 626 183
showtext 0 0 4
pause 1 1 1 1 1 1 1 1
**
eff.exe a02_623a.gif 1 388 0 1 0 15 15 15
eff.exe a02_623b.gif 142 246 0 1 0 15 15 15
*                                   The blue arrows indicate the c
isave 336 188 626 132 text3
growbox 336 188 626 132
showtext 0 0 3
pause 1 1 1 1 1 1 1 1
**
image memory text3 0 336 188
image memory text2 0 336 256
image memory text1 0 336 285
footnote 0
*
eff.exe a02_624a.gif 1 424 0 1 0 15 15 15
eff.exe a02_624b.gif 142 246 0 1 0 15 15 15
*                                   As you can see, cell A1 is ref
isave 362 185 610 134 text1
textbox 362 185 610 134
showtext 0 0 2
pause 1 1 1 1 1 1 1 1
**
qcall AE02q 020404
eff.exe a02_625a.gif 0 424 0 1 0 15 15 15
*                                   A1 contains text, and the form
isave 362 139 610 66 text2
growbox 362 139 610 66
showtext 0 0 4
pause 1 1 1 1 1 1 1 1
**
image memory text2 0 362 139
image memory text1 0 362 185
*
eff.exe a02_626a.gif 0 431 0 1 0 15 15 15
eff.exe a02_626b.gif 369 432 0 1 0 15 15 15
eff.exe a02_626c.gif 0 16 0 1 0 15 15 15
eff.exe a02_626d.gif 369 16 0 1 0 15 15 15
*                                   You can correct the error by c
isave 311 228 585 160 text1
textbox 311 228 585 160
showtext 0 0 3
pause 1 1 1 1 1 1 1 1
**
image memory text1 0 311 228
*
*
*          Topic:    Hands-on: Correcting precedents        Topic No.: 7
****

simscrn 2 14 14
MoveCtrl 1 493 460 0 0
*
isave 8 452 286 333 text1
textbox 8 452 286 333
showtext 0 0 6
pause 1 1 1 1 1 1 1 1
**
isave 8 338 286 248 text2
growbox 8 338 286 248
showtext 0 0 5
pause 1 1 1 1 1 1 1 1
**
isave 8 253 286 197 text3
growbox 8 253 286 197
showtext 0 0 3
pause 1 1 1 1 1 1 1 1
**
image memory text3 0 8 253
image memory text2 0 8 338
image memory text1 0 8 452
***********************
*
*
*
exercise 03 1 120 70
task 04 0204 0 300 280 7 120 67 35 75
*
pause 1 1 1 1 1 1 1 1
*********************
*********************