Opening one spreadsheet from another spreadsheet using a picture with a URL some
ID: 3565679 • Letter: O
Question
Opening one spreadsheet from another spreadsheet using a picture with a URL somehow hides the newly opened spreadsheet
My client has a product based on Excel Spreadsheets. He has an initial menu with a set of pictures each of which is associated with a Hyperlink pointing to a related spreadsheet. This product has worked for years on the PC in Office 2003 and beyond with no problems. We are now porting this to the Mac and when a button is clicked it appears to load the related spreadsheet, but once the initial Workbook_Open code has completed, the workbook 'disappears'. You can see it on the list of workbooks under the Excel Windows menu item, but clicking on the item will not display it. Opening the workbook by itself works fine. It is only when you launch it by a Hyperlink does it disappear. I have checked the VBA code, because we have had a number of problems with VBA code not compiling correctly, but it compiles fine.
In VBA, activating the workbook using the immediate window has no effect. It appears to be open, it is just invisible.
Does anyone have some suggestions as to why this might only be happening on the MAC and not Windows? Any suggestions on how I can troubleshoot this? There is nothing obvious about the workbook or the sheets to indicate they are hidden. The visibility property says they should be visible. The menu says they should be visible, but they are not visibele.
Thanks in advance!!,
Explanation / Answer
The workbook is probably positioned "off screen". This may happen with different platforms due to screen size and resolutions. Work books are saved with their window positions, so they will open in the position they were when saved. Try arrnaging the windows, either manually or via VBA to position them where you want them.
Checkthis:-)
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.