Guide to Managing Permissions for Custom Workbooks
Amber Schmitz
|
88 steps
|
5 minutes
1
Click "P"
2
Click "P"
3
Click "Allow Edit Ranges"
4
Click here:
5
Click here:
6
Click "Range1"
7
Click "Range1"
8
Type "GRC COMMENTS [[tab]]"
9
Type " [[tab]]"
10
Type "CURRENT BOT"
11
Click "Permissions"
12
Click "Add..."
13
Click "Enter the object names to select (<A>examples</A>):"
14
Type "SCHMITZ [[enter]]"
15
Click "Add..."
16
Type "CRABTREE [[enter]]"
17
Click "Add..."
18
Type "WILSON [[enter]]"
19
Click "Wilson, Vicki"
20
Click "OK"
21
Click "Add..."
22
Type "HAMAN [[enter]]"
23
Click "Add..."
24
Type "LEFFLER [[enter]]"
25
Click "Add..."
26
Click here:
27
Type "BLANSIT [[enter]]"
28
Click "Add..."
29
Type "SIMONE [[enter]]"
30
Click "Add..."
31
Type "WESOLEK [[enter]]"
32
Click "Add..."
33
Type "PRUITT [[enter]]"
34
Click "DPruitt"
35
Click "OK"
36
Click "Add..."
37
Type "SONVANE [[enter]]"
38
Click "Add..."
39
Type "HARSURE [[enter]]"
40
Click "Add..."
41
Type "SISODIYA [[enter]]"
42
Click "Add..."
43
Type "BIRW"
44
Press [[ctrl]] + [[delete]]
45
Type "NIRWAN [[enter]]"
46
Click "Schmitz, Amber (ASchmitz@ttiinc.com)"
47
Click "Blansit, Heather (HBlansit@ttiinc.com)"
48
Click "Haman, Monique (MHaman@ttiinc.com)"
49
Click "Simone, Dorothy (DSimone@ttiinc.com)"
50
Click "Line down"
51
Click "Allow Edit range without a password"
52
Click "Allow Edit range without a password"
53
Click "OK"
54
Click "OK"
55
Type "CURRENT BOT [[enter]]"
56
Click "Paste permissions information into a new workbook"
57
Click "Protect Sheet..."
58
Click "Use AutoFilter"
59
Click "Password to unprotect sheet"
60
Type "CURRENT BOT"
61
Click "OK"
62
Click "Format cells"
63
Click "Format columns"
64
Click "Format columns"
65
Click "Format cells"
66
Click "Format cells"
67
Click "Format cells"
68
Click "OK"
69
Click "Reenter password to proceed."
70
Type "CURRENT BOT [[enter]]"
71
Click "N7"
72
Type "DDDDD"
73
Click "U9"
74
Type "S"
75
Click "N22"
76
Type "SSS"
77
Click here:
78
Click "U16"
79
Click "U22"
80
Type "FFFGF [[enter]]"
81
Click "U22"
82
Click "No filter applied"
83
Click "N5"
84
Click "No filter applied"
85
Click "T7"
86
Click "W5"
87
Click "V6"
88
Click here:
