There is another way of unhiding all hidden and very hidden worksheets: Using VBA. Steps for pasting the VBA function to your Excel WorkbookĪgain, this is primarily revelant for older versions of Excel (not Office 365 since beginning of 2021 if you are on the current Excel version please scroll up).