Toggle system objects

  • Thread starter Margaret Bartley
  • Start date
M

Margaret Bartley

Is there a way to use VBA or write a macro to toggle whether the System
Objects are visible? This is on the General tab of the Options form.
 
S

Stuart McCall

Margaret Bartley said:
Is there a way to use VBA or write a macro to toggle whether the System
Objects are visible? This is on the General tab of the Options form.
Click to expand...

Application.SetOption "Show System Objects", True

will switch them on

Application.SetOption "Show System Objects", False

will switch them off

HTH
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hide Table Using VBA 26
Toggle Filter in multiple subforms 3
Check whether form is is 'edit' mode 1
Using toggle button to turn filter on and off 1
Excel 2007: ActiveWorkbook with VBA 2
Toggle button vs Command button 2
Toggle Button for Visible Command 1
Toggle "Save sent messages to..." 1

Top