By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,316 Members | 2,317 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,316 IT Pros & Developers. It's quick & easy.

Turn off View Hidden and System Objects in code

P: n/a
Is it possible to use VBA to turn off the View Hidden objects and System
objects?

dixie
Nov 13 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a

"Dixie" <di***@dogmail.com> wrote in message
news:43********@duster.adelaide.on.net...
Is it possible to use VBA to turn off the View Hidden objects and System
objects?

dixie


Not sure about the system objects, but:

Application.SetOption "Show Hidden Objects", vbFalse

works for the hidden.

Cheers,
Randy

Nov 13 '05 #2

P: n/a
Yes, it is.

Nov 13 '05 #3

P: n/a
Yep, same idea works for the system objects too. Thanks Randy.

dixie

"Randy Harris" <ra***@SpamFree.com> wrote in message
news:zE*****************@newssvr17.news.prodigy.co m...

"Dixie" <di***@dogmail.com> wrote in message
news:43********@duster.adelaide.on.net...
Is it possible to use VBA to turn off the View Hidden objects and System
objects?

dixie


Not sure about the system objects, but:

Application.SetOption "Show Hidden Objects", vbFalse

works for the hidden.

Cheers,
Randy

Nov 13 '05 #4

P: n/a
lylefair wrote:
Yes, it is.


You're just doing doing this to annoy David aren't you? :-)
Nov 13 '05 #5

P: n/a
Trevor Best wrote:
You're just doing doing this to annoy David aren't you? :-)


Hi Trevor

That would be pointless. I don't have to do anything to annoy David.

Nov 13 '05 #6

P: n/a

"lylefair" <ly***********@aim.com> wrote in message
news:11*********************@g49g2000cwa.googlegro ups.com...
Trevor Best wrote:
You're just doing doing this to annoy David aren't you? :-)


Hi Trevor

That would be pointless. I don't have to do anything to annoy David.


LOL

Larry
Nov 13 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.