Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Unable to set the ..." in Excel 97
Howdy
I'm having some problems with my file created in xl2002 when opened in xl 97 in that I am getting a variety of "Unable to set the ..." errors, such as "Unable to set the locked property of the Range class" or "Unable to set the hidden property of the range class". I did some Goggle groups searches on this group, and the latter error (which was the error I encountered) seemed to be because I was trying to hide 5 rows that were either locked or protected or both. When I selected the entire sheet and 'unlocked' the cells (as well as the fact that the sheet wasn't protected anyway) and tried again with my procedure to hide the rows and I still got the same error, I came across this procedure Private Sub CommandButton3_Click() Dim myDoc As Worksheet Dim cel As Range Set myDoc = ActiveSheet myDoc.Unprotect For Each cel In myDoc.UsedRange cel.Locked = False Next End Sub which I tried to use to clear any locking or protection problems, but now I'm getting the first error I listed above. What's going on? Thanks Matt |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Unable to set the ..." in Excel 97
Set the takefocusonclick property of the commandbutton to False.
-- Regards, Tom Ogilvy "Matt Jensen" wrote in message ... Howdy I'm having some problems with my file created in xl2002 when opened in xl 97 in that I am getting a variety of "Unable to set the ..." errors, such as "Unable to set the locked property of the Range class" or "Unable to set the hidden property of the range class". I did some Goggle groups searches on this group, and the latter error (which was the error I encountered) seemed to be because I was trying to hide 5 rows that were either locked or protected or both. When I selected the entire sheet and 'unlocked' the cells (as well as the fact that the sheet wasn't protected anyway) and tried again with my procedure to hide the rows and I still got the same error, I came across this procedure Private Sub CommandButton3_Click() Dim myDoc As Worksheet Dim cel As Range Set myDoc = ActiveSheet myDoc.Unprotect For Each cel In myDoc.UsedRange cel.Locked = False Next End Sub which I tried to use to clear any locking or protection problems, but now I'm getting the first error I listed above. What's going on? Thanks Matt |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Unable to set the ..." in Excel 97
%$^&*&^*
Unbelievable!! Why is it like that? (I actually just activated range A1 in the worksheet in the VBA procedure code to fix it) Thanks Matt "Tom Ogilvy" wrote in message ... Set the takefocusonclick property of the commandbutton to False. -- Regards, Tom Ogilvy "Matt Jensen" wrote in message ... Howdy I'm having some problems with my file created in xl2002 when opened in xl 97 in that I am getting a variety of "Unable to set the ..." errors, such as "Unable to set the locked property of the Range class" or "Unable to set the hidden property of the range class". I did some Goggle groups searches on this group, and the latter error (which was the error I encountered) seemed to be because I was trying to hide 5 rows that were either locked or protected or both. When I selected the entire sheet and 'unlocked' the cells (as well as the fact that the sheet wasn't protected anyway) and tried again with my procedure to hide the rows and I still got the same error, I came across this procedure Private Sub CommandButton3_Click() Dim myDoc As Worksheet Dim cel As Range Set myDoc = ActiveSheet myDoc.Unprotect For Each cel In myDoc.UsedRange cel.Locked = False Next End Sub which I tried to use to clear any locking or protection problems, but now I'm getting the first error I listed above. What's going on? Thanks Matt |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Unable to set the ..." in Excel 97
It is a bug in Excel 97 fixed in later versions.
-- Regards, Tom Ogilvy "Matt Jensen" wrote in message ... %$^&*&^* Unbelievable!! Why is it like that? (I actually just activated range A1 in the worksheet in the VBA procedure code to fix it) Thanks Matt "Tom Ogilvy" wrote in message ... Set the takefocusonclick property of the commandbutton to False. -- Regards, Tom Ogilvy "Matt Jensen" wrote in message ... Howdy I'm having some problems with my file created in xl2002 when opened in xl 97 in that I am getting a variety of "Unable to set the ..." errors, such as "Unable to set the locked property of the Range class" or "Unable to set the hidden property of the range class". I did some Goggle groups searches on this group, and the latter error (which was the error I encountered) seemed to be because I was trying to hide 5 rows that were either locked or protected or both. When I selected the entire sheet and 'unlocked' the cells (as well as the fact that the sheet wasn't protected anyway) and tried again with my procedure to hide the rows and I still got the same error, I came across this procedure Private Sub CommandButton3_Click() Dim myDoc As Worksheet Dim cel As Range Set myDoc = ActiveSheet myDoc.Unprotect For Each cel In myDoc.UsedRange cel.Locked = False Next End Sub which I tried to use to clear any locking or protection problems, but now I'm getting the first error I listed above. What's going on? Thanks Matt |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
"Unable to Read File" error message in Excel - solutions? | Excel Discussion (Misc queries) | |||
i am unable to find "Text to speech" tool bar in Office2007 excel | Excel Discussion (Misc queries) | |||
unable to load "Excel" analysis toolpak tried the tools and brows | Excel Discussion (Misc queries) | |||
"Unable to Open File" - excel output of Datagrid <-help needed | Excel Programming |