2024 Tus sau: Elizabeth Oswald | [email protected]. Kawg hloov kho: 2023-12-17 02:46
Yuav ua li cas kom tsis txhob zais cov ntawv zais heev hauv Excel
Nias "Image" + F11 los qhib Visual Basic Editor.
Nyob rau hauv lub qhov rais VBAProject, xaiv daim ntawv koj xav kom unhide.
Nyob rau hauv lub qhov rais Properties, teem lub Visible cuab tam rau -1 - xlSheetVisible.
Koj qhib cov ntawv zais hauv Excel li cas?
Hidden
Txhawm rau nkaum ib daim ntawv, tsuas yog nyem rau ntawm daim ntawv tab thiab xaiv zais. …
Txhawm rau tshem tawm daim ntawv, tsuas yog nyem rau ntawm ib daim ntawv tab thiab xaiv Unhide. …
Xaiv daim ntawv zais thiab nyem ok. …
Nyob rau sab laug sab laug yog qhov Project Explorer, qhov twg koj tuaj yeem siv tsob ntoo mus rau txhua phau ntawv qhib, thiab rau ib daim ntawv.
Vim li cas thiaj tsis zais greyed tawm hauv Excel?
Yog hais tias Unhide hais kom ua greyed tawm ob qho tib si ntawm ribbon thiab nyob rau hauv txoj cai-nias ntawv qhia zaub mov, txhais tau tias tsis muaj ib daim ntawv zais hauv koj phau ntawv ua haujlwm:) Qhov no yog li cas koj unhidenplooj ntawv hauv Excel.
Kuv yuav tiv thaiv Excel li cas los ntawm Unhideing?
Trick kom nkaum daim ntawv (tsis yooj yim rau unhide) yam tsis muaj kev tiv thaiv phau ntawv
Right Click on the sheet to Hide.
Click on View Code.
Nyob rau hauv lub qhov rais VBA dov mus rau daim ntawv cov khoom.