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: Melissa King   on Oct 18

I guess this would need to be done right when the workbook opens, and
this was one of the things that I have tried, as described in my last
post in his topic, and that did not work.

Now in your reply, you wrote:
> "I notice that you've set the sheet  to "very hidden"."
I think you misread my post.
I wrote:
> For now, since I still need to see that sheet very often, I
did not use Dave's proposal for ThisWorkbook.Sheets("Sheet2").Visible
= xlSheetVeryHidden
>I guess I'll introduce that only later.

You also wrote:
>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 this is exactly what my macros do when they use the hidden sheet.
When a macro  need to update a webquery, it has to select the right
one, so I had to name the cell where the red "!" shows up indicating
that this is the beginning of the webquery that I want to update.

That is why I was so happy to be able to un hide  them but to
deactivate the screen updating,
Application.ScreenUpdating=False
because else the hiding  of the sheet would have been pretty useless:
without that part of code, I came back exactly to the situation that
I wanted to avoid.

All your replies brought me to try other things that did not work
well, but I will post  them separately, because for the
moment, without them everything seems to work well, and I still have
more urgent things in order to complete a first test workbook to send
to the site administrator.

One of those tasks being to replace by functions some cells where I
have so long formulas with tons of IF(... and AND( ; ;) that the
formula takes almost 3 lines, and I myself, when I look at them, I
can't remember why I wrote that, except that I know that they had to
be like that.
Now that I know how to write functions, I could easier document the
formulas with comments.

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: