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

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
 
M

MikeR

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.
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Coding Help for Beginner 0
Slight VBA hickup 3
Problem in adding macro to ribbon through Add-in 7
Password security 1
Macro to unhide all except for. . . 5
Spell Check 3
Protection Macro 2
Hide Macro 3

Top