Paul Sansom
Board Regular
- Joined
- Jan 28, 2013
- Messages
- 178
- Office Version
- 2021
- 2016
- Platform
- Windows
Hi
The following code works to make visible all sheets following different views, and i have been trying every syntax for a 1 line solution
Is there a command like...Application.Sheets.Visible = xlSheetVisible. ?? (Note this does no work in Objects).
Cheers Paul
The following code works to make visible all sheets following different views, and i have been trying every syntax for a 1 line solution
Code:
For Each ws In Sheets
ws.Visible = xlSheetVisible
Next ws
Is there a command like...Application.Sheets.Visible = xlSheetVisible. ?? (Note this does no work in Objects).
Cheers Paul