Excel keeps setting hidden sheets to the "SheetHidden" option in VBA

B

bnbcat

New Member
Joined
Apr 27, 2016
Messages
41
Office Version
  1. 365
Platform
  1. Windows
I'm not sure what is going on, but when I hide sheets, I can't unhide them unless I go to VBA and change the "Visible" setting to xlSheetVisible. This is for ALL files I open. Does anyone know how to turn this off? Thank you!
 

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.
Sort by date Sort by votes
How do you want to unhide them after hiding?
What do you see when you right click on any of the visible tabs?
 
Upvote 0
You must log in or register to reply here.

Similar threads

B
  • Solved
Worksheet Change - multiple Loops in one sub
2
Replies
15
Views
341
mumps
mumps
M
  • Question
Need multiple buttons to hide/show rows on another tab
Replies
8
Views
426
skillilea
S
H
  • Question
How to hide some columns while allowing users to 'Format Columns'
Replies
2
Views
314
hcgood
H
L
  • Question
VBA code not working on Mac
Replies
7
Views
609
Jim Gordon
J
P
  • Question
Help With VBA Script
Replies
0
Views
168
Pirate_tat87
P

Forum statistics

Threads
1,215,585
Messages
6,125,679
Members
449,248
Latest member
wayneho98

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top