Protecting/Unprotecting all sheets with macro leads to "image" iss

  • Thread starter Thread starter MikeR
  • Start date Start date
M

MikeR

After I run the macro code (see below) to protect or unprotect all sheets
images from other areas of the spreadsheet appear at random when I start to
input in cells. They go away if you page down and up again or leave the
sheet and come back. I tested this on other computes and I get the same
effect. I am running Excel 2007 but the file is in 2003 format (not all
users are on 2007). I did save the file in 2007 macro-enabled format and
have the same issues.

Code:
Sub Unprotect_All_Sheets()
Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets
ws.Unprotect Password:="password"
Next ws
End Sub

Sub Protect_All_Sheets()
Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets
ws.Protect Password:="password"
Next ws
End Sub
 
I copied the same code into another (older) Excel file and get the same
problem. Looks like it might be a conversion issue to 2007???

Any insight would be greatly appreciated.
 
Probably the result of the security updates on November 10th, 2009

KB973593 affected 2007 and KB973475 affected 2003

Thhere is a hotfix for 2007

KB973593 / 2007 hotfix

978522 Description of the Office Excel 2007 hotfix package
(Excel-x-none.msp, Xlconv-x-none.msp): December 23, 2009

http://support.microsoft.com/default.aspx?scid=kb;EN-US;978522

I don't know if there was a hotfix for KB973475


Gord Dibben MS Excel MVP
 
Back
Top