How to unhide multiple sheets in Microsoft Excel

Поділитися
Вставка
  • Опубліковано 26 сер 2024
  • How to unhide multiple sheets multiple sheets in Microsoft Excel
    1. Press: Alt+F11 (opens the VB Editor Window)
    2. Press: Ctrl+G (opens the Immediate Window)
    3. Paste the following line of code in the Immediate Window and press Enter
    For Each ws In Sheets:ws.Visible=True:Next

КОМЕНТАРІ • 7