{"id":242,"date":"2024-07-27T14:50:59","date_gmt":"2024-07-27T12:50:59","guid":{"rendered":"https:\/\/gezhi-tech.com\/?p=242"},"modified":"2026-01-18T04:32:57","modified_gmt":"2026-01-18T03:32:57","slug":"a-tools-for-fill-trf-hyperlink-trf","status":"publish","type":"post","link":"https:\/\/gezhi-tech.com\/vi\/a-tools-for-fill-trf-hyperlink-trf\/","title":{"rendered":"C\u00f4ng c\u1ee5 \u0111i\u1ec1n TRF \u2013 Hyperlink TRF"},"content":{"rendered":"N\u1ebfu b\u1ea1n c\u1ea7n \u0111i\u1ec1n v\u00e0o TRF (m\u1eabu b\u00e1o c\u00e1o th\u1eed nghi\u1ec7m) theo ti\u00eau chu\u1ea9n s\u00ea-ri IEC 60335, t\u00f4i \u0111o\u00e1n b\u1ea1n ch\u1eafc ch\u1eafn s\u1ebd c\u1ea3m th\u1ea5y TRF c\u00f3 qu\u00e1 nhi\u1ec1u trang. L\u00e0m c\u00e1ch n\u00e0o \u0111\u1ec3 nhanh ch\u00f3ng x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed con tr\u1ecf \u0111\u1ebfn m\u1ed9t v\u1ecb tr\u00ed nh\u1ea5t \u0111\u1ecbnh trong b\u00e1o c\u00e1o? B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng t\u00ecm ki\u1ebfm (ctrl+F), ho\u1eb7c s\u1eed d\u1ee5ng con l\u0103n chu\u1ed9t, ho\u1eb7c s\u1eed d\u1ee5ng c\u00e1c ph\u00edm trang tr\u00ean b\u00e0n ph\u00edm, \u0111i\u1ec1u n\u00e0y kh\u00f4ng thu\u1eadn ti\u1ec7n l\u1eafm. N\u1ebfu b\u1ea1n s\u1eed d\u1ee5ng VBA \u0111\u1ec3 vi\u1ebft m\u00e3 macro, vi\u1ebft ch\u1ee9c n\u0103ng \u0111\u1ecbnh v\u1ecb v\u00e0o m\u00e3 macro v\u00e0 ch\u1ea1y m\u00e3 macro, b\u1ea1n c\u00f3 th\u1ec3 nhanh ch\u00f3ng x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed nh\u1ea5t \u0111\u1ecbnh th\u01b0\u1eddng xuy\u00ean \u0111\u01b0\u1ee3c y\u00eau c\u1ea7u trong TRF.
\u1ede \u0111\u00e2y, t\u00f4i \u0111\u00e3 vi\u1ebft m\u1ed9t m\u00e3 macro m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 t\u1ea3i tr\u1ef1c ti\u1ebfp xu\u1ed1ng m\u00e1y t\u00ednh c\u00e1 nh\u00e2n c\u1ee7a m\u00ecnh. B\u1ea1n c\u00f3 th\u1ec3 t\u1ea3i xu\u1ed1ng t\u1eeb \u1edf \u0111\u00e2y<\/a>. \u0110\u1eebng qu\u00ean gi\u1ea3i n\u00e9n t\u1eadp tin.
\n
\n\u0110\u1ec3 s\u1eed d\u1ee5ng c\u00e1c macro n\u00e0y khi \u0111i\u1ec1n TRF \u0111\u1ecbnh d\u1ea1ng Word, b\u1ea1n c\u1ea7n th\u1ef1c hi\u1ec7n c\u00e1c c\u00e0i \u0111\u1eb7t sau: T\u00f9y ch\u1ecdn t\u1ec7p-Trung t\u00e2m tin c\u1eady-C\u00e0i \u0111\u1eb7t trung t\u00e2m tin c\u1eady-C\u00e0i \u0111\u1eb7t macro-B\u1eadt t\u1ea5t c\u1ea3 c\u00e1c macro (kh\u00f4ng \u0111\u01b0\u1ee3c khuy\u1ebfn ngh\u1ecb; m\u00e3 nguy hi\u1ec3m ti\u1ec1m t\u00e0ng c\u00f3 th\u1ec3 ch\u1ea1y) ho\u1eb7c T\u1eaft t\u1ea5t c\u1ea3 c\u00e1c macro ngo\u1ea1i tr\u1eeb macro \u0111\u01b0\u1ee3c k\u00fd \u0111i\u1ec7n t\u1eed. Sau \u0111\u00f3, b\u1ea1n c\u1ea7n kh\u1edfi \u0111\u1ed9ng l\u1ea1i ch\u01b0\u01a1ng tr\u00ecnh Word.
\n
\nTr\u01b0\u1edbc khi s\u1eed d\u1ee5ng macro, b\u1ea1n c\u1ea7n nh\u1eadp macro nh\u1eefng g\u00ec b\u1ea1n v\u1eeba t\u1ea3i xu\u1ed1ng v\u00e0o Word. T\u00f4i khuy\u00ean d\u00f9ng ph\u01b0\u01a1ng ph\u00e1p sau.
\u0110\u1eb7t chu\u1ed9t tr\u00ean thanh c\u00f4ng c\u1ee5 Word, nh\u1ea5p chu\u1ed9t ph\u1ea3i, ch\u1ecdn “T\u00f9y ch\u1ec9nh robbin”, ch\u1ecdn “T\u00f9y ch\u1ec9nh ruy-b\u0103ng” \u1edf b\u00ean tr\u00e1i h\u1ed9p tho\u1ea1i b\u1eadt l\u00ean v\u00e0 ch\u1ecdn “Nh\u00e0 ph\u00e1t tri\u1ec3n” trong c\u1eeda s\u1ed5 b\u00ean ph\u1ea3i. \u0110\u00f3ng c\u1eeda s\u1ed5 l\u1ea1i. L\u00fac n\u00e0y thanh c\u00f4ng c\u1ee5 Developer s\u1ebd xu\u1ea5t hi\u1ec7n tr\u00ean thanh c\u00f4ng c\u1ee5 Word c\u1ee7a b\u1ea1n.
Tr\u01b0\u1edbc khi s\u1eed d\u1ee5ng macro, b\u1ea1n c\u1ea7n nh\u1eadp macro v\u1eeba t\u1ea3i xu\u1ed1ng v\u00e0o Word. T\u00f4i khuy\u00ean d\u00f9ng ph\u01b0\u01a1ng ph\u00e1p sau.
\u0110\u1eb7t chu\u1ed9t tr\u00ean thanh c\u00f4ng c\u1ee5 Word, nh\u1ea5p chu\u1ed9t ph\u1ea3i, ch\u1ecdn T\u00f9y ch\u1ec9nh robbin, ch\u1ecdn T\u00f9y ch\u1ec9nh Ribbon \u1edf ph\u00eda b\u00ean tr\u00e1i c\u1ee7a h\u1ed9p tho\u1ea1i b\u1eadt l\u00ean v\u00e0 ch\u1ecdn Nh\u00e0 ph\u00e1t tri\u1ec3n trong c\u1eeda s\u1ed5 b\u00ean ph\u1ea3i. \u0110\u00f3ng c\u1eeda s\u1ed5 l\u1ea1i. L\u00fac n\u00e0y thanh c\u00f4ng c\u1ee5 Developer s\u1ebd xu\u1ea5t hi\u1ec7n tr\u00ean thanh c\u00f4ng c\u1ee5 Word c\u1ee7a b\u1ea1n.
Ch\u1ecdn thanh c\u00f4ng c\u1ee5 d\u00e0nh cho nh\u00e0 ph\u00e1t tri\u1ec3n, nh\u1ea5p v\u00e0o n\u00fat Visual Basic \u1edf b\u00ean tr\u00e1i, ch\u1ecdn B\u00ecnh th\u01b0\u1eddng \u1edf b\u00ean tr\u00e1i h\u1ed9p tho\u1ea1i b\u1eadt l\u00ean, nh\u1ea5p chu\u1ed9t ph\u1ea3i, nh\u1ea5p v\u00e0o Nh\u1eadp t\u1ec7p, ch\u1ecdn t\u1ec7p macro \u0111\u00e3 t\u1ea3i xu\u1ed1ng trong h\u1ed9p tho\u1ea1i b\u1eadt l\u00ean v\u00e0 nh\u1ea5n OK \u0111\u1ec3 nh\u1eadp. T\u1ea1i th\u1eddi \u0111i\u1ec3m n\u00e0y, macro \u0111\u00e3 \u0111\u01b0\u1ee3c nh\u1eadp v\u00e0o m\u00e1y t\u00ednh c\u00e1 nh\u00e2n c\u1ee7a b\u1ea1n.
\n
\nKhi b\u1ea1n ch\u1ea1y macro th\u00f4ng qua View-Macros-ch\u1ecdn macro d\u1ef1a tr\u00ean t\u00ean Macro \u1edf c\u1eeda s\u1ed5 b\u00ean tr\u00e1i ch\u1ea1y, s\u1ebd r\u1ea5t c\u1ed3ng k\u1ec1nh v\u00e0 c\u00e1ch t\u1ed1t nh\u1ea5t \u0111\u1ec3 th\u1ef1c hi\u1ec7n l\u00e0 \u0111\u1eb7t c\u00e1c ch\u1ee9c n\u0103ng macro n\u00e0y tr\u00ean thanh c\u00f4ng c\u1ee5. K\u1ebft qu\u1ea3 sau khi nh\u1eadp \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb b\u00ean d\u01b0\u1edbi\uff1a
\n

\n\"\"
\n<\/figure>
\n\u0110\u1ec3 \u0111\u1eb7t c\u00e1c ch\u1ee9c n\u0103ng macro tr\u00ean thanh c\u00f4ng c\u1ee5, b\u1ea1n c\u1ea7n t\u00f9y ch\u1ec9nh thanh c\u00f4ng c\u1ee5. \u0110\u1eb7t chu\u1ed9t tr\u00ean thanh c\u00f4ng c\u1ee5, nh\u1ea5p chu\u1ed9t ph\u1ea3i, ch\u1ecdn “T\u00f9y ch\u1ec9nh robbin”, ch\u1ecdn “T\u00f9y ch\u1ec9nh ruy-b\u0103ng” \u1edf b\u00ean tr\u00e1i v\u00e0 ch\u1ecdn “Macro” trong menu th\u1ea3 xu\u1ed1ng “Ch\u1ecdn l\u1ec7nh t\u1eeb:”. B\u00e2y gi\u1edd b\u1ea1n c\u00f3 th\u1ec3 xem t\u1ea5t c\u1ea3 c\u00e1c macro \u0111\u01b0\u1ee3c li\u1ec7t k\u00ea trong h\u1ed9p hi\u1ec3n th\u1ecb b\u00ean d\u01b0\u1edbi. Nh\u1ea5p v\u00e0o n\u00fat “Tab m\u1edbi” trong h\u1ed9p tho\u1ea1i b\u00ean ph\u1ea3i v\u00e0 b\u1ea1n s\u1ebd th\u1ea5y nh\u00e3n “Tab m\u1edbi (T\u00f9y ch\u1ec9nh)” \u0111\u01b0\u1ee3c th\u00eam v\u00e0o h\u1ed9p n\u1ed9i dung ph\u00eda tr\u00ean. B\u1ea1n c\u00f3 th\u1ec3 b\u1ea5m v\u00e0o n\u00fat \u0110\u1ed5i t\u00ean \u0111\u1ec3 \u0111\u1ed5i t\u00ean, sau \u0111\u00f3 b\u1ea5m v\u00e0o n\u00fat Th\u00eam gi\u1eefa hai h\u1ed9p n\u1ed9i dung \u0111\u1ec3 th\u00eam macro \u1edf h\u1ed9p n\u1ed9i dung b\u00ean tr\u00e1i v\u00e0o h\u1ed9p n\u1ed9i dung b\u00ean ph\u1ea3i. Th\u00eam c\u00e1c macro b\u1ea1n c\u1ea7n. Sau khi ho\u00e0n th\u00e0nh, b\u1ea1n c\u00f3 th\u1ec3 s\u1eafp x\u1ebfp v\u00e0 thay \u0111\u1ed5i t\u00ean c\u1ee7a t\u1eebng macro (b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 thay \u0111\u1ed5i ki\u1ec3u bi\u1ec3u t\u01b0\u1ee3ng). Nh\u1ea5p v\u00e0o n\u00fat OK. Xin ch\u00fac m\u1eebng, b\u1ea1n \u0111\u00e3 th\u00eam th\u00e0nh c\u00f4ng macro v\u00e0o thanh c\u00f4ng c\u1ee5 Word. Sau \u0111\u00f3, t\u1ea5t c\u1ea3 t\u00e0i li\u1ec7u Word b\u1ea1n m\u1edf \u0111\u1ec1u c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng macro tr\u00ean thanh c\u00f4ng c\u1ee5.
\nH\u00e3y th\u1eed c\u00e1c macro n\u00e0y \u0111\u1ec3 xem li\u1ec7u ch\u00fang c\u00f3 th\u1ec3 gi\u00fap b\u1ea1n \u0111i\u1ec1u h\u01b0\u1edbng nhanh ch\u00f3ng \u0111\u1ebfn c\u00e1c v\u1ecb tr\u00ed nh\u1ea5t \u0111\u1ecbnh trong b\u00e1o c\u00e1o c\u1ee7a b\u1ea1n hay kh\u00f4ng.<\/strong>","protected":false},"excerpt":{"rendered":"

N\u1ebfu b\u1ea1n c\u1ea7n \u0111i\u1ec1n v\u00e0o TRF (m\u1eabu b\u00e1o c\u00e1o th\u1eed nghi\u1ec7m) theo ti\u00eau chu\u1ea9n s\u00ea-ri IEC 60335, t\u00f4i \u0111o\u00e1n b\u1ea1n ch\u1eafc ch\u1eafn s\u1ebd c\u1ea3m th\u1ea5y TRF c\u00f3 qu\u00e1 nhi\u1ec1u trang. L\u00e0m c\u00e1ch n\u00e0o \u0111\u1ec3 nhanh ch\u00f3ng x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed con tr\u1ecf \u0111\u1ebfn m\u1ed9t v\u1ecb tr\u00ed nh\u1ea5t \u0111\u1ecbnh trong b\u00e1o c\u00e1o? B\u1ea1n c\u00f3 th\u1ec3 s\u1eed…<\/p>","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_kadence_starter_templates_imported_post":false,"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"footnotes":""},"categories":[2],"tags":[156],"class_list":["post-242","post","type-post","status-publish","format-standard","hentry","category-general","tag-tools"],"translation":{"provider":"WPGlobus","version":"3.0.1","language":"vi","enabled_languages":["en","es","ar","de","ja","fr","ru","th","nl","it","fa","ko","pt","hi","ro","tr","vi","id","zu"],"languages":{"en":{"title":true,"content":true,"excerpt":false},"es":{"title":true,"content":true,"excerpt":false},"ar":{"title":true,"content":true,"excerpt":false},"de":{"title":true,"content":true,"excerpt":false},"ja":{"title":true,"content":true,"excerpt":false},"fr":{"title":true,"content":true,"excerpt":false},"ru":{"title":true,"content":true,"excerpt":false},"th":{"title":true,"content":true,"excerpt":false},"nl":{"title":true,"content":true,"excerpt":false},"it":{"title":true,"content":true,"excerpt":false},"fa":{"title":true,"content":true,"excerpt":false},"ko":{"title":true,"content":true,"excerpt":false},"pt":{"title":true,"content":true,"excerpt":false},"hi":{"title":true,"content":true,"excerpt":false},"ro":{"title":true,"content":true,"excerpt":false},"tr":{"title":true,"content":true,"excerpt":false},"vi":{"title":true,"content":true,"excerpt":false},"id":{"title":true,"content":true,"excerpt":false},"zu":{"title":true,"content":true,"excerpt":false}}},"_links":{"self":[{"href":"https:\/\/gezhi-tech.com\/vi\/wp-json\/wp\/v2\/posts\/242","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gezhi-tech.com\/vi\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/gezhi-tech.com\/vi\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/gezhi-tech.com\/vi\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/gezhi-tech.com\/vi\/wp-json\/wp\/v2\/comments?post=242"}],"version-history":[{"count":31,"href":"https:\/\/gezhi-tech.com\/vi\/wp-json\/wp\/v2\/posts\/242\/revisions"}],"predecessor-version":[{"id":2871,"href":"https:\/\/gezhi-tech.com\/vi\/wp-json\/wp\/v2\/posts\/242\/revisions\/2871"}],"wp:attachment":[{"href":"https:\/\/gezhi-tech.com\/vi\/wp-json\/wp\/v2\/media?parent=242"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gezhi-tech.com\/vi\/wp-json\/wp\/v2\/categories?post=242"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gezhi-tech.com\/vi\/wp-json\/wp\/v2\/tags?post=242"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}