Yet another question...pretty general

Posted by RoB on August 14, 2001 9:18 PM

boy, I'm going for a record of posts in one day. Thanks to Everyone who responded, you're all great.

Ok, I have 2 files, which I saved as a workspace. I hid all the rows and outline symbols, but when I open the workspace, it opens them back up. Is there a way to prevent this?

Thanks yet again.

Posted by Robb on August 14, 2001 9:45 PM

Rob

I have never noticed any similar issue - are you saving the changes after they are made?

Regards

Posted by Robb on August 15, 2001 1:08 AM

Rob

Thought about it some more and I see what you meant - the outline symbols return.

I am not sure why it does that, but a way round it is to set the property in Workbook_Open. Try puting something like this in the code module of ThisWorkbook:

Private Sub Workbook_Open()
Worksheets("Sheet1").Outline.ShowLevels rowlevels:=1
Workbooks("whatever.xls").Worksheets("sheet1").Activate
ActiveWindow.DisplayOutline = False
End Sub

I took a guess that rowlevel 1 would be appropriate, but you can set it to whatever you like.

You may also do this via the Worksheet_Activate but, if the workbook opens to the sheet, it may not take effect until the user goes to another sheet and returns. There are ways round that, but using Workbooks_Open seems to be the way to go.

Any help?