Workbook functionality not working after reopening?

[kmk2702]

This is my first project working with Excel and VBA. It’s been fun… until now.
I have a workbook with several sheets filled with data. In the workbook I use, among other things, drop down lists, grouping and protection functionality. It all looks fine after I run the code, then I save and close the workbook. Next time I open the workbook, suddenly I can’t group/ungroup (+/-) and in one of the sheets (the one with most rows) the drop down lists suddenly stop being there?
I use allowformattingrows:=true, which works just after I run the code and all of the drop down lists are there. I tried to run the protection code on workbook_open event, but it didn’t help.

Heres the protection code:
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, userInterfaceOnly:=True, Scenarios:=True, Password:="kogj", AllowFormattingRows:=True, AllowFormattingColumns:=True, AllowFiltering:=True

What can be wronge? Thanks for the help.

[royUK]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

[kmk2702]

Hello Forum
This is my first project working with Excel and VBA. It’s been fun… until now.
I have a workbook with several sheets filled with data. In the workbook I use, among other things, drop down lists, grouping and protection functionality. It all looks fine after I run the code, then I save and close the workbook. Next time I open the workbook, suddenly I can’t group/ungroup (+/-) and in one of the sheets (the one with most rows) the drop down lists suddenly stop being there?
I use allowformattingrows:=true, which works just after I run the code and all of the drop down lists are there. I tried to run the protection code on workbook_open event, but it didn’t help.

Heres the protection code:

Please Login or Register  to view this content.

What can be wronge? Thanks for the help.