{"id":6629,"date":"2024-06-30T13:59:25","date_gmt":"2024-06-30T13:59:25","guid":{"rendered":"https:\/\/tech-lib.eu\/tech\/?p=6629"},"modified":"2024-06-30T13:59:25","modified_gmt":"2024-06-30T13:59:25","slug":"jak-uzamknout-bunky-v-tabulkach-google-pruvodce-krok-za-krokem","status":"publish","type":"post","link":"https:\/\/tech-lib.eu\/tech\/jak-uzamknout-bunky-v-tabulkach-google-pruvodce-krok-za-krokem\/","title":{"rendered":"Jak uzamknout bu\u0148ky v tabulk\u00e1ch Google. Pr\u016fvodce krok za krokem"},"content":{"rendered":"
P\u0159i pou\u017e\u00edv\u00e1n\u00ed Tabulek Google k organizaci a anal\u00fdze dat m\u016f\u017eete ob\u010das cht\u00edt nastavit ur\u010dit\u00e9 bu\u0148ky jako chr\u00e1n\u011bn\u00e9 p\u0159ed \u00fapravami nebo zm\u011bnami. Uzam\u010den\u00ed bun\u011bk v Tabulk\u00e1ch Google v\u00e1m m\u016f\u017ee poskytnout po\u017eadovanou ochranu a kontrolu, a\u0165 u\u017e chcete zabr\u00e1nit ne\u00famysln\u00fdm zm\u011bn\u00e1m d\u016fle\u017eit\u00fdch dat, nebo omezit p\u0159\u00edstup ke konkr\u00e9tn\u00edm bu\u0148k\u00e1m. V tomto p\u0159\u00edsp\u011bvku se pod\u00edv\u00e1me na mnoho zp\u016fsob\u016f uzamyk\u00e1n\u00ed bun\u011bk v Tabulk\u00e1ch Google a tak\u00e9 na n\u011bkter\u00e9 \u010dasto kladen\u00e9 ot\u00e1zky t\u00fdkaj\u00edc\u00ed se uzamyk\u00e1n\u00ed bun\u011bk. <\/p>\n
<\/div>\n

1. Vyu\u017eit\u00ed funkce Chr\u00e1nit listy a rozsahy: Jedn\u00edm z nejjednodu\u0161\u0161\u00edch zp\u016fsob\u016f uzam\u010den\u00ed bun\u011bk v Listech Google je pou\u017eit\u00ed funkce „Chr\u00e1nit listy a rozsahy“. Postupujte podle n\u00e1sleduj\u00edc\u00edch krok\u016f, abyste toho dos\u00e1hli: <\/p>\n

<\/div>\n

Otev\u0159ete dokument Tabulky Google a vyberte bu\u0148ky, kter\u00e9 chcete v prvn\u00edm kroku uzamknout. <\/p>\n

<\/div>\n

Krok 2: V rozev\u00edrac\u00ed nab\u00eddce vyberte mo\u017enost „Chr\u00e1nit listy a rozsahy“ kliknut\u00edm na mo\u017enost „Data“ na panelu nab\u00eddek. Krok 3: Chcete-li omezit, kdo m\u016f\u017ee chr\u00e1n\u011bn\u00e9 bu\u0148ky upravovat, vyberte v postrann\u00edm panelu, kter\u00fd se zobraz\u00ed na prav\u00e9 stran\u011b str\u00e1nky, mo\u017enost „Nastavit opr\u00e1vn\u011bn\u00ed“. <\/p>\n

<\/div>\n

Krok 4: Do pole „Konkr\u00e9tn\u00ed rozsah“ v \u010d\u00e1sti „Rozsah“ zadejte rozsah bun\u011bk, kter\u00fd chcete uzamknout. Krok 5: Upravte opr\u00e1vn\u011bn\u00ed podle sv\u00fdch po\u017eadavk\u016f. Nap\u0159\u00edklad m\u016f\u017eete ur\u010dit\u00fdm u\u017eivatel\u016fm povolit zobrazen\u00ed nebo aktualizaci rozsahu. Krok 6: Chcete-li zm\u011bny ulo\u017eit, klikn\u011bte na tla\u010d\u00edtko „Nastavit opr\u00e1vn\u011bn\u00ed“. <\/p>\n

<\/div>\n

Krok 7: Chcete-li prov\u00e9st uzam\u010den\u00ed bun\u011bk, stiskn\u011bte nakonec v postrann\u00edm panelu mo\u017enost „Hotovo“. <\/p>\n

2. Bu\u0148ky, kter\u00e9 jsou po zad\u00e1n\u00ed dat uzam\u010deny: Abyste dos\u00e1hli sv\u00e9ho c\u00edle, pou\u017eijte skript Google Apps k automatick\u00e9mu uzam\u010den\u00ed bun\u011bk po zad\u00e1n\u00ed dat. Postup je n\u00e1sleduj\u00edc\u00ed: <\/div>\n

Jakmile je dokument Tabulky Google otev\u0159en, vyberte v nab\u00eddce polo\u017eku „Roz\u0161\u00ed\u0159en\u00ed“. <\/p>\n

<\/div>\n

Krok 2: V rozev\u00edrac\u00ed nab\u00eddce vyberte „Apps Script“, \u010d\u00edm\u017e spust\u00edte editor Apps Script na nov\u00e9 kart\u011b. <\/p>\n

<\/div>\n

Krok 3: Do editoru vlo\u017ete n\u00e1sleduj\u00edc\u00ed k\u00f3d: <\/p>\n

<\/div>\n

“’javascript <\/p>\n

<\/div>\n

function onEdit(e) var sheet = e.source.getActiveSheet(); var range = e.range; <\/p>\n

<\/div>\n

sheet.protect().setDescription(‚Locked‘).setRange(range).removeEditors(sheet.getEditors()); <\/p>\n

<\/div>\n

“‘ <\/p>\n

<\/div>\n

Krok 4: Ulo\u017ete skript stisknut\u00edm kl\u00e1ves Ctrl + S nebo kliknut\u00edm na ikonu diskety. <\/p>\n

<\/div>\n

V kroku 5 zav\u0159ete editor skript\u016f aplikac\u00ed a vra\u0165te se k tabulce. <\/p>\n

<\/div>\n

Krok 6: Skript automaticky uzamkne bu\u0148ku, pokud jsou do n\u00ed vlo\u017eena nebo aktualizov\u00e1na data. <\/p>\n

<\/div>\n

3. Bu\u0148ky, kter\u00e9 se uzamknou na z\u00e1klad\u011b podm\u00ednky: <\/p>\n

<\/div>\n

A\u010dkoli podm\u00edn\u011bn\u00e9 uzam\u010den\u00ed bun\u011bk nen\u00ed vestav\u011bnou funkc\u00ed aplikace Tabulky Google, m\u016f\u017eete ho p\u0159esto dos\u00e1hnout kombinac\u00ed spou\u0161t\u011b\u010d\u016f skript\u016f a krit\u00e9ri\u00ed pro ov\u011b\u0159ov\u00e1n\u00ed dat. Obecn\u00fd zp\u016fsob podm\u00edn\u011bn\u00e9ho zamyk\u00e1n\u00ed bun\u011bk je n\u00e1sleduj\u00edc\u00ed: <\/p>\n

<\/div>\n

Na bu\u0148ky, kter\u00e9 chcete za ur\u010dit\u00fdch podm\u00ednek v kroku 1 uzamknout, pou\u017eijte pravidla pro ov\u011b\u0159ov\u00e1n\u00ed dat. M\u016f\u017eete nap\u0159\u00edklad vytvo\u0159it vlastn\u00ed pravidlo vzorce, kter\u00e9 se pou\u017eije pouze za ur\u010dit\u00fdch okolnost\u00ed. <\/p>\n

<\/div>\n

Ve druh\u00e9m kroku napi\u0161te skript, kter\u00fd v z\u00e1vislosti na po\u017eadavc\u00edch na platnost bu\u0148ky uzamkne nebo odemkne. <\/p>\n

<\/div>\n

Krok 3: Pou\u017eijte spou\u0161t\u011b\u010d skriptu pro spu\u0161t\u011bn\u00ed skriptu p\u0159i spln\u011bn\u00ed podm\u00ednek, nap\u0159\u00edklad spou\u0161t\u011b\u010d „P\u0159i \u00faprav\u011b“. <\/p>\n

<\/div>\n

4. \u00daprava bun\u011bk p\u0159i ponech\u00e1n\u00ed nechr\u00e1n\u011bn\u00fdch list\u016f: <\/p>\n

<\/div>\n

Pomoc\u00ed funkce „Chr\u00e1nit listy a rozsahy“ popsan\u00e9 v prvn\u00ed technice uzamkn\u011bte bu\u0148ky pro \u00fapravy, ani\u017e byste chr\u00e1nili cel\u00fd list. M\u00edsto v\u00fdb\u011bru cel\u00e9ho listu m\u016f\u017eete vybrat rozsah bun\u011bk a zm\u011bnit opr\u00e1vn\u011bn\u00ed. T\u00edmto zp\u016fsobem m\u016f\u017eete ud\u011blit ur\u010dit\u00fd p\u0159\u00edstup r\u016fzn\u00fdm osob\u00e1m nebo skupin\u00e1m a z\u00e1rove\u0148 omezit \u00fapravy na ur\u010dit\u00fdch m\u00edstech. <\/p>\n

<\/div>\n

Z\u00e1v\u011brem lze \u0159\u00edci, \u017ee funkce zamyk\u00e1n\u00ed bun\u011bk v tabulk\u00e1ch Google nab\u00edz\u00ed praktick\u00fd p\u0159\u00edstup k zabezpe\u010den\u00ed dat a omezen\u00ed p\u0159\u00edstupu ke konkr\u00e9tn\u00edm bu\u0148k\u00e1m. V\u00fd\u0161e uveden\u00e9 p\u0159\u00edstupy poskytuj\u00ed \u0159adu alternativ, kter\u00e9 odpov\u00eddaj\u00ed va\u0161im pot\u0159eb\u00e1m, a\u0165 u\u017e chcete zabr\u00e1nit necht\u011bn\u00fdm aktualizac\u00edm, nebo omezit \u00fapravy na z\u00e1klad\u011b okolnost\u00ed. Zabezpe\u010den\u00ed a integritu sv\u00fdch dat m\u016f\u017eete zajistit pomoc\u00ed vestav\u011bn\u00fdch n\u00e1stroj\u016f a skript\u016f v tabulk\u00e1ch Google.<\/p><\/div>\n

\n
FAQ<\/div>\n
\n
Mohu uzamknout sloupec v Tabulk\u00e1ch Google?<\/div>\n

V Tabulk\u00e1ch Google lze sloupec skute\u010dn\u011b uzamknout. Zamknut\u00edm sloupce m\u016f\u017eete omezit jeho zm\u011bnu nebo dopln\u011bn\u00ed a z\u00e1rove\u0148 umo\u017enit \u00fapravu ostatn\u00edch sloupc\u016f. <\/p>\n<\/div>\n

\n
Jak uzamknout bu\u0148ky, ale povolit zad\u00e1v\u00e1n\u00ed dat?<\/div>\n

Chcete-li v Tabulk\u00e1ch Google uzamknout bu\u0148ky a p\u0159itom umo\u017enit zad\u00e1v\u00e1n\u00ed dat, prove\u010fte n\u00e1sleduj\u00edc\u00ed akce: Otev\u0159ete dokument Tabulky Google v kroku 1. 2. Klikn\u011bte a p\u0159et\u00e1hn\u011bte kurzor my\u0161i na bu\u0148ky, kter\u00e9 chcete chr\u00e1nit, abyste je vybrali. 3. V rozev\u00edrac\u00ed nab\u00eddce vyberte mo\u017enost „Chr\u00e1nit rozsah“, kdy\u017e k v\u00fdb\u011bru bun\u011bk pou\u017eijete prav\u00e9 tla\u010d\u00edtko my\u0161i. 4. V postrann\u00edm panelu, kter\u00fd se zobraz\u00ed na prav\u00e9 stran\u011b obrazovky, vyberte tla\u010d\u00edtko „Nastavit opr\u00e1vn\u011bn\u00ed“. 5. V rozev\u00edrac\u00ed nab\u00eddce vedle polo\u017eky „Omezit, kdo m\u016f\u017ee upravovat tento rozsah“ v \u010d\u00e1sti „Opr\u00e1vn\u011bn\u00ed k rozsahu“ vyberte mo\u017enost „Pouze vy“ nebo konkr\u00e9tn\u00ed osoby, kter\u00fdm chcete umo\u017enit upravovat bu\u0148ky. Kdy\u017e se n\u011bkdo pokus\u00ed upravit chr\u00e1n\u011bn\u00e9 bu\u0148ky, zobraz\u00ed se varovn\u00e1 zpr\u00e1va, pokud je za\u0161krtnuto pol\u00ed\u010dko vedle „Zobrazit varov\u00e1n\u00ed p\u0159i \u00faprav\u011b tohoto rozsahu“. Chcete-li zm\u011bny ulo\u017eit, pou\u017eijte tla\u010d\u00edtko „Hotovo“ v kroku 7. <\/p>\n

<\/div>\n

Tyto metody v\u00e1m umo\u017en\u00ed uzamknout bu\u0148ky v tabulk\u00e1ch Google a z\u00e1rove\u0148 umo\u017enit ur\u010den\u00fdm osob\u00e1m zad\u00e1vat data. <\/p>\n<\/div>\n

\n
Jak automaticky uzamknout bu\u0148ku po zad\u00e1n\u00ed dat?<\/div>\n

Chcete-li, aby aplikace Tabulky Google automaticky uzamkla bu\u0148ku po zad\u00e1n\u00ed dat, m\u016f\u017eete prov\u00e9st tyto kroky: Otev\u0159ete Tabulky Google a vyberte bu\u0148ku nebo rozsah bun\u011bk, kter\u00e9 chcete v dokumentu uzamknout. 2. V nab\u00eddce v horn\u00ed \u010d\u00e1sti obrazovky vyberte mo\u017enost „Form\u00e1tovat“. 3. V rozev\u00edrac\u00ed nab\u00eddce vyberte mo\u017enost „Chr\u00e1nit listy a rozsahy“. 4. Na prav\u00e9 stran\u011b obrazovky se objev\u00ed postrann\u00ed panel. V tomto postrann\u00edm panelu klikn\u011bte na mo\u017enost „Nastavit opr\u00e1vn\u011bn\u00ed“. 5. V dialogov\u00e9m okn\u011b „Nastavit opr\u00e1vn\u011bn\u00ed“ m\u016f\u017eete vybrat, kdo m\u00e1 mo\u017enost upravovat vybran\u00fd rozsah. Bude p\u0159ednastaveno „Pouze vy“. V p\u0159\u00edpad\u011b pot\u0159eby m\u016f\u017eete pr\u00e1va k \u00faprav\u00e1m ud\u011blit tak\u00e9 vybran\u00e9 skupin\u011b osob. V kroku 6 za\u0161krtn\u011bte mo\u017enost vedle polo\u017eky „Zobrazit upozorn\u011bn\u00ed p\u0159i \u00faprav\u00e1ch tohoto rozsahu.“. Kdy\u017e se n\u011bkdo pokus\u00ed upravit uzam\u010denou bu\u0148ku nebo rozsah, zobraz\u00ed se varovn\u00e1 zpr\u00e1va. Pokud byste cht\u011bli b\u00fdt upozorn\u011bni, kdy\u017e n\u011bkdo usiluje o p\u0159\u00edstup k \u00faprav\u00e1m uzam\u010den\u00e9 bu\u0148ky nebo rozsahu, m\u016f\u017eete tak\u00e9 za\u0161krtnout pol\u00ed\u010dko „Upozornit m\u011b, kdy\u017e ostatn\u00ed po\u017e\u00e1daj\u00ed o p\u0159\u00edstup k \u00faprav\u00e1m“. 8. Chcete-li ulo\u017eit sv\u00e9 volby, klikn\u011bte na tla\u010d\u00edtko „Nastavit opr\u00e1vn\u011bn\u00ed“. Ka\u017ed\u00fd, kdo se pokus\u00ed zm\u011bnit uzam\u010denou bu\u0148ku nebo rozsah, nyn\u00ed dostane upozorn\u011bn\u00ed a bude muset p\u0159edt\u00edm po\u017e\u00e1dat o povolen\u00ed. Uzam\u010denou bu\u0148ku nebo rozsah m\u016f\u017eete m\u011bnit pouze vy nebo ti ostatn\u00ed, kter\u00fdm byla ud\u011blena pr\u00e1va k \u00faprav\u00e1m.<\/p>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

P\u0159i pou\u017e\u00edv\u00e1n\u00ed Tabulek Google k organizaci a anal\u00fdze dat m\u016f\u017eete ob\u010das cht\u00edt nastavit ur\u010dit\u00e9 bu\u0148ky jako chr\u00e1n\u011bn\u00e9 p\u0159ed \u00fapravami nebo zm\u011bnami. Uzam\u010den\u00ed bun\u011bk v Tabulk\u00e1ch Google v\u00e1m m\u016f\u017ee poskytnout po\u017eadovanou ochranu a kontrolu, a\u0165 u\u017e chcete zabr\u00e1nit ne\u00famysln\u00fdm zm\u011bn\u00e1m d\u016fle\u017eit\u00fdch dat, nebo omezit p\u0159\u00edstup ke konkr\u00e9tn\u00edm bu\u0148k\u00e1m. V tomto p\u0159\u00edsp\u011bvku se pod\u00edv\u00e1me na mnoho zp\u016fsob\u016f … \u010c\u00edst d\u00e1l<\/a><\/p>\n","protected":false},"author":3627,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[],"class_list":["post-6629","post","type-post","status-publish","format-standard","hentry","category-technologie"],"_links":{"self":[{"href":"https:\/\/tech-lib.eu\/tech\/wp-json\/wp\/v2\/posts\/6629","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tech-lib.eu\/tech\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tech-lib.eu\/tech\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tech-lib.eu\/tech\/wp-json\/wp\/v2\/users\/3627"}],"replies":[{"embeddable":true,"href":"https:\/\/tech-lib.eu\/tech\/wp-json\/wp\/v2\/comments?post=6629"}],"version-history":[{"count":1,"href":"https:\/\/tech-lib.eu\/tech\/wp-json\/wp\/v2\/posts\/6629\/revisions"}],"predecessor-version":[{"id":16101,"href":"https:\/\/tech-lib.eu\/tech\/wp-json\/wp\/v2\/posts\/6629\/revisions\/16101"}],"wp:attachment":[{"href":"https:\/\/tech-lib.eu\/tech\/wp-json\/wp\/v2\/media?parent=6629"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tech-lib.eu\/tech\/wp-json\/wp\/v2\/categories?post=6629"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tech-lib.eu\/tech\/wp-json\/wp\/v2\/tags?post=6629"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}