View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Shawn Shawn is offline
external usenet poster
 
Posts: 271
Default Code Glitch from version to version

Sub Run_Update1()
Application.ScreenUpdating = False
Sheets("Sheet1").Unprotect Password:="George"

Why does this code work fine in all Excel versions except Windows 95 Excel
97? It freezes at the Unprotect line. I have about 200 computers running
this and about 5 run Windows 95 and Excel 97. The rest run version 2000 or
better. On all the 95/97 computers the code freezes at the Unprotect line of
code???

--
Thanks
Shawn