Tsis tuaj yeem qhib cov nplooj ntawv hauv excel?

Cov txheej txheem:

Tsis tuaj yeem qhib cov nplooj ntawv hauv excel?
Tsis tuaj yeem qhib cov nplooj ntawv hauv excel?
Anonim

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

    1. Txhawm rau nkaum ib daim ntawv, tsuas yog nyem rau ntawm daim ntawv tab thiab xaiv zais. …
    2. Txhawm rau tshem tawm daim ntawv, tsuas yog nyem rau ntawm ib daim ntawv tab thiab xaiv Unhide. …
    3. Xaiv daim ntawv zais thiab nyem ok. …
    4. 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

    1. Right Click on the sheet to Hide.
    2. Click on View Code.
    3. Nyob rau hauv lub qhov rais VBA dov mus rau daim ntawv cov khoom.
    4. Nyob rau hauv qhov pom kev poob qis xaiv Very Hidden.
    5. Qhov no yuav ua kom ntseeg tau tias qhov kev xaiv unhide yog greyed tawm thaum ib tug neeg sim unhide daim ntawv hauv Excel.

    3 Methods to Unhide All Sheets in Excel (& how to hide)

    3 Methods to Unhide All Sheets in Excel (& how to hide)
    3 Methods to Unhide All Sheets in Excel (& how to hide)
    43 cov lus nug ntsig txog pom

    Pom zoo: