Excel 95 Vs Excel 2000

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The code below works in Excel 2000 and later. Two or three of my users are
stuck with Excl and Window 95 on old machines. The code freezes up on the
Unprotect line in the 95 Excel programs. Why? How can I fix it?

Sub Update_Date()
Application.ScreenUpdating = False
Sheets("Ino.").Unprotect Password:="Time"
 
Setting ScreeUpdating to False has the effect of freezing the screen: I take
it you have application.screenupdating=true somewhere?
 
Yes. It does ScreenUpdate later. Would the code work on 95 if I put the
unprotect before the screenupdate = false?
 
Back
Top