Snakehips
Well-known Member
- Joined
- May 17, 2009
- Messages
- 6,029
- Office Version
- 365
- Platform
- MacOS
Firstly, thanks to all who may take the time to read this.
I have contributed to an Excel project by virtue of supplying some simple automation code which, for the most part, just password controls access / sheet visibility.
So sheets are either visible or are very hidden depending upon user status / task in hand.
***** When opened in Excel 2007 or Excel 2010 there are no issues. *****
However when opened in Excel 2013 we get the following.......
Initially, the 'blank' workbook opens with only the Information sheet visible. At this point, any of the data cells will accept data and changes to that data.
However, the user needs to enter at least four key data elements in order to be able to Configure the visibility of sheets.
Example Issue:
Once the user enters the key data they hit the Configure button which appropriately reveal other sheets.
After this configuration, any data entry / edit in certain cells results in the screen displaying a partial overlay of another sheet!!!!!
Eg...
www.dropbox.com/s/yp1pnetuqlgd9hk/2013-Issue.gif?dl=0
If you then cause the screen to refresh by e.g. a scroll or select another sheet then the Information sheet is aok.
The issue will repeat until such time as you force the refresh by clicking on the offending overlay sheet, in this case PROV SS-18 After that the issue is fixed and does not re-occur.
The above is one of several similar scenarios.
I appear to have worked around this by adding a line of code to the Configure routine so that during the loop through the worksheets it activates every sheet in turn before either hiding or showing it.
So although arguably no longer a real problem, I would be very keen to understand why this should be happening and only in Excel 2013
I have contributed to an Excel project by virtue of supplying some simple automation code which, for the most part, just password controls access / sheet visibility.
So sheets are either visible or are very hidden depending upon user status / task in hand.
***** When opened in Excel 2007 or Excel 2010 there are no issues. *****
However when opened in Excel 2013 we get the following.......
Initially, the 'blank' workbook opens with only the Information sheet visible. At this point, any of the data cells will accept data and changes to that data.
However, the user needs to enter at least four key data elements in order to be able to Configure the visibility of sheets.
Example Issue:
Once the user enters the key data they hit the Configure button which appropriately reveal other sheets.
After this configuration, any data entry / edit in certain cells results in the screen displaying a partial overlay of another sheet!!!!!
Eg...
www.dropbox.com/s/yp1pnetuqlgd9hk/2013-Issue.gif?dl=0
If you then cause the screen to refresh by e.g. a scroll or select another sheet then the Information sheet is aok.
The issue will repeat until such time as you force the refresh by clicking on the offending overlay sheet, in this case PROV SS-18 After that the issue is fixed and does not re-occur.
The above is one of several similar scenarios.
I appear to have worked around this by adding a line of code to the Configure routine so that during the loop through the worksheets it activates every sheet in turn before either hiding or showing it.
So although arguably no longer a real problem, I would be very keen to understand why this should be happening and only in Excel 2013