I know it's a cliche Dunbar but... thanks for sharing!!!
Anyone got a reason for this???
Lisa
Lisa
-----Original Message-----
From: h_dunbar@hotmail.com [ExcelVBA] <ExcelVBA@yahoogroups.com>
To: ExcelVBA <ExcelVBA@yahoogroups.com>
Sent: Mon, Aug 17, 2015 1:32 pm
Subject: [ExcelVBA] My e-mailed Excel file disappears from view when I "enable macros", yet I can fetch it from Downloads.
From: h_dunbar@hotmail.com [ExcelVBA] <ExcelVBA@yahoogroups.com>
To: ExcelVBA <ExcelVBA@yahoogroups.com>
Sent: Mon, Aug 17, 2015 1:32 pm
Subject: [ExcelVBA] My e-mailed Excel file disappears from view when I "enable macros", yet I can fetch it from Downloads.
I developed an Excel sheet using Excel 2003. When I email it to another computer that is running Office 2013 and I open the attachment, the initial screen appears, as well as whatever sheet tabs ought to be visible. The name of the workbook has "[Protected View] [Repaired]" added at the end.
When I click on "Enable Editing", the screen flashes white a couple of times, and then stays white. The only things visible are the ribbon headers. If I run my cursor over the place where sheet tabs should be, the sheet tabs become visible, but they are not selectable. Nor can I close Excel.
If I click on "File", the 'Close' option is not available. If I click 'Open' and try to select a recent workbook, it will not act on it.
BUT, if I force Excel to clo se using the Task Manager and then re-open it, the emailed workbook shows as the most recent download. If I click to open it, it opens and is fully functional. "[Compatibility Mode]" has replaced "[Protected View] [Repaired]".
After that, it works fine.
I originally wrote this up to ask for help. But I figured out what's going on and I have a go-around. I still don't know why it's happening.
Here's why it's going white. After the"Enable Editing" click, for some reason Excel is trying to move to a sheet tab that's one to the left of the original selected worksheet. When there is no tab to the left, the screen goes white and Excel locks up. When I added a sheet to the left, the e-mailed workbook opens without a problem, albeit, lo oking at the wrong worksheet. So, that 'dummy' sheet now is all black except for a button to "Start The Program".
I found my own inelegant solution, but I still have no idea why this is happening with this workbook.
--Dunbar
__._,_.___
Posted by: Green <1z@compuserve.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
.
__,_._,___
Tidak ada komentar:
Posting Komentar