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

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.
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
256
mumps
mumps
M
  • Question
Need multiple buttons to hide/show rows on another tab
Replies
8
Views
398
skillilea
S
H
  • Question
How to hide some columns while allowing users to 'Format Columns'
Replies
2
Views
284
hcgood
H
L
  • Question
VBA code not working on Mac
Replies
7
Views
571
Jim Gordon
J
P
  • Question
Help With VBA Script
Replies
0
Views
145
Pirate_tat87
P

Forum statistics

Threads
1,215,068
Messages
6,122,950
Members
449,095
Latest member
nmaske

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