I have a workbook with macros which are able to access the data in the worksheets and function normally. However, if the workbook is opened (with or without any macros executing) no worksheets are displayed. What is displayed is a blank window with a small icon in the lower left of the window where worksheets are normally displayed. (See attached screen capture.)
The "Visible" property of each sheet is -1 which means that the sheet is visible.
If I open the "View" tab, almost everything is greyed out including "Window/New Window".
I have no way to see or access the worksheet data except via the macros.
Any help will be MUCH appreciated. Thanks!
Bookmarks