locked
How do I find out the view mode for an inactive sheet? RRS feed

  • Question

  • How do I find out the view mode for an inactive sheet?

    This works with the active sheet, what will the code look like for an inactive sheet?

    Application.ActiveWindow.View
    Saturday, April 25, 2020 12:47 PM

Answers

  • You can't. View is a property of the Window object, not of the Worksheet object. You'll have to activate a sheet to find the view mode of its window.

    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    • Marked as answer by MSDN Member Monday, April 27, 2020 4:27 AM
    Saturday, April 25, 2020 7:11 PM