Excel 97 - xlNoSelection - problem
Hi all,
I have set the Worksheet properties to xlNoSelection (for certain sheets) in a Excel 97 workbook. However if l save the workbook close it, then re-open it the subject sheets have reverted to xlNoRestrictions ! The original workbook, written for XL2003, works fine. Anybody know what causes this and if there is a solution / workaround. TIA Regards Michael Beckinsale |
Excel 97 - xlNoSelection - problem
Workaround: (code in thisworkbook module..) Private Sub Workbook_Open() Dim wks As Worksheet If Val(Application.Version) = 8 Then For Each wks In Me.Worksheets wks.EnableSelection = xlNoSelection Next End If End Sub -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam Michael Beckinsale wrote in Hi all, I have set the Worksheet properties to xlNoSelection (for certain sheets) in a Excel 97 workbook. However if l save the workbook close it, then re-open it the subject sheets have reverted to xlNoRestrictions ! The original workbook, written for XL2003, works fine. Anybody know what causes this and if there is a solution / workaround. TIA Regards Michael Beckinsale |
Excel 97 - xlNoSelection - problem
keepITcool,
Thanks for the reply & solution which of course works fine. I have had to modify it slightly so it only applies to the specific sheets l need restricted. Do you know if this is a bug in Excel 97 ? Can you confirm that Excel 97=8, Excel 2000=9, Excel 2003=10 please ? Thinking about it what is Excel XP ? |
Excel 97 - xlNoSelection - problem
dont know about the other versions.
remove the version check in the routine and you should be fine. -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam wrote in groups.com keepITcool, Thanks for the reply & solution which of course works fine. I have had to modify it slightly so it only applies to the specific sheets l need restricted. Do you know if this is a bug in Excel 97 ? Can you confirm that Excel 97=8, Excel 2000=9, Excel 2003=10 please ? Thinking about it what is Excel XP ? |
Excel 97 - xlNoSelection - problem
keepITcool,
Found the list of version numbers etc on John Walkenbachs' site if your interested. http://j-walk.com/ss/excel/index.htm |
Excel 97 - xlNoSelection - problem
When set by code (only method is that shown by KeepItCool) in any version
(xl97 and later), it is not persistant When set manually in xl2002 and later it is persistant. -- Regards, Tom Ogilvy wrote in message oups.com... keepITcool, Thanks for the reply & solution which of course works fine. I have had to modify it slightly so it only applies to the specific sheets l need restricted. Do you know if this is a bug in Excel 97 ? Can you confirm that Excel 97=8, Excel 2000=9, Excel 2003=10 please ? Thinking about it what is Excel XP ? |
All times are GMT +1. The time now is 09:40 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com