Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding rows in a protected sheet in Excel 2003
I have a spreadsheet that was developed in Excel 2000.
This spreadsheet is using lots of hiding of rows to customize it for the user. It works fine in 97, 2000 and Xp. But in 2003 I had to add lots of lines of code to unprotect the document every time a row is opened or closed. Are there any ways around this as it makes the program very slow even on a fast computer. Best regards, Urban |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding rows in a protected sheet in Excel 2003
Can you provide a simple example that demonstrates the problem?
As far as I know Excel 2003 is no different that earlier Excels. If a worksheet is protect in code with UserInterfaceOnly set to True then a macro can hide rows with the worksheet protected. If UserInterfaceOnly is not true then the macro will error trying to hide a row. -- Jim Rech Excel MVP |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding rows in a protected sheet in Excel 2003
Thnaks for the help. Here is a sample how it is done.
Private Sub HideL_Project_Type() ' Opens and closes sections relevant to selected project Range("HideL_Arena").EntireRow.Hidden = True Range("HideL_Retail").EntireRow.Hidden = True If Range("HideCodeL_Proj").Value = 1 Then Range("HideL_Arena").EntireRow.Hidden = False ElseIf Range("HideCodeL_Proj").Value = 2 Then Range("HideL_Retail").EntireRow.Hidden = False End If End Sub We are using pulldown menues to select different types of options. You can also go to our web site www.retscreen.net and download any of our programs. I tried the Biomass model on Excel 2003 and it totally crashes. We have about 37,000 users for these programs so we need a fix. I will try your suggestion later today. When I tried using unprotect before every Hidden statement it started to work again. Thanks, Urban -----Original Message----- Can you provide a simple example that demonstrates the problem? As far as I know Excel 2003 is no different that earlier Excels. If a worksheet is protect in code with UserInterfaceOnly set to True then a macro can hide rows with the worksheet protected. If UserInterfaceOnly is not true then the macro will error trying to hide a row. -- Jim Rech Excel MVP . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding rows in a protected sheet in Excel 2003
Any chance you could email me the Biomass file? I really don't want to go
through the registration process on your site. Thanks. -- Jim Rech Excel MVP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inserting rows in a protected sheet - Office 2003 | Excel Worksheet Functions | |||
hiding even (or odd) rows in excel 2003 | Excel Discussion (Misc queries) | |||
Recalculation on hiding rows in Excel 2003 | Excel Discussion (Misc queries) | |||
Hiding rows while sheet is protected | Excel Discussion (Misc queries) | |||
HIDING ROWS IN PROTECTED WORKSHEETS | Excel Discussion (Misc queries) |