Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: George Evans   on Oct 18 In MS Office Category.

  
Question Answered By: Jennie Harris   on Oct 18

I notice that you've set the sheet  to "very hidden". This might be further
than you want to go. "Very hidden" can only be unhidden by VBA code and is
there to protect things that the user MUST NOT see - usually in conjunction
with a password-protected VBA project.

"Ordinary" hidden would be plenty for things that you'd prefer that the user
doesn't see.

You also say that macros can't reach your sheet once it is hidden. In fact,
macros (VBA code) can access hidden sheets without trouble. It's only when
they try to do things that would normally cause the sheet or its cells to
come into view that you'll have trouble. I.e. you can't select or activate
cells on a hidden sheet, but the code can make normal direct use of the
cells without problems.

Share: 

 

This Question has 8 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Is it possible to detect Excel version? Or get search suggestion and latest updates.


Tagged: