Thread: Hiding rows in a protected sheet in Excel 2003
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Rech Jim Rech is offline
external usenet poster
  
Posts: 2,718
Default 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


Reply With QuoteReply With Quote