Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code Glitch from version to version
Hi
Not really sure what the problem is, but I have run into errors with protecting in excel 97 on occasion. I have found that if you select a cell first, you don't get those occasional errors. I know you are not supposed to have to select and selecting slows things down, but this is just my personal experience with excel 97. Sub Run_Update1() Sheets("Sheet1").Range("a1").select Application.ScreenUpdating = False Sheets("Sheet1").Unprotect Password:="George" if doing additional sheets, select a cell on the next sheet as well like Sub Run_Update1() Application.ScreenUpdating = False Sheets("Sheet1").Range("a1").select Sheets("Sheet1").Unprotect Password:="George" Sheets("Sheet2").Range("a1").select Sheets("Sheet2").Unprotect Password:="George" Application.ScreenUpdating = True HTH Ken |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code Glitch from version to version
This is worth a try and is probably just "silly" enough to work. Thanks for
the pointer. "Ken Macksey" wrote: Hi Not really sure what the problem is, but I have run into errors with protecting in excel 97 on occasion. I have found that if you select a cell first, you don't get those occasional errors. I know you are not supposed to have to select and selecting slows things down, but this is just my personal experience with excel 97. Sub Run_Update1() Sheets("Sheet1").Range("a1").select Application.ScreenUpdating = False Sheets("Sheet1").Unprotect Password:="George" if doing additional sheets, select a cell on the next sheet as well like Sub Run_Update1() Application.ScreenUpdating = False Sheets("Sheet1").Range("a1").select Sheets("Sheet1").Unprotect Password:="George" Sheets("Sheet2").Range("a1").select Sheets("Sheet2").Unprotect Password:="George" Application.ScreenUpdating = True HTH Ken |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I save an Excel 97-2003 version or 2007 version for Mac 200 | Excel Discussion (Misc queries) | |||
Wrap Text: Print Version different than Screen Version | Excel Discussion (Misc queries) | |||
How can I get the same colors from 2003 version to 2007 version? | Excel Discussion (Misc queries) | |||
Help Required!!! Macro to load data from version 1 to version 2 | Excel Worksheet Functions | |||
Recover earlier version of excel sheet after new version saved? | Excel Discussion (Misc queries) |