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?
 

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

Code Glitch from version to version 2
Simple VBA Code written in Excel 2003 not working in Excel 2000 4
Macro to prompt for password to unprotect worksheets 2
Unlock Code 1
Custom Toolbar Add-in 1
Workbook_BeforeClose 2
Save as problem for Excel 97/2000 (with VBA-protection in excel 20 3
Code not working in a PROTECTED Worksheet 2

Back
Top