Share via

Very Hidden Function in Excel for Mac

Anonymous
2017-08-22T16:33:08+00:00

Hi,

I was trying to locate the Properties Window or a place  where I can open the visible/hidden/very hidden function in Excel on Mac. Where can I find it?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Jim G 134K Reputation points MVP Volunteer Moderator
    2017-08-25T16:52:05+00:00

    To set a worksheet's property to veryhidden use:

    Sheets("SheetName").Visible = xlVeryHidden

    To unhide use:

    Sheets("SheetName").Visible = True

    Was this answer helpful?

    0 comments
  2. Anonymous
    2017-08-23T02:29:48+00:00

    Hi SliRC,

    This option is not available in Excel 2016 for Mac. Microsoft is working on porting the Visual Basic Editor from Excel 2011 for Mac to Excel 2016 for Mac(In Excel 2011, we can go to Tools > Macro > Visual Basic Editor > F6 to access Properties Window).

    Given this situation, I suggest you submit your feedback at Excel UserVoicewhich is the best way to let related team hear your voice. You can also vote for the following topic:

    Bring back a fully functional VBE (Visual Basic Editor for VBA)

    Regards,

    William

    Was this answer helpful?

    0 comments