Merging workbook code

[tuckjoseph]

I currently have the following code that allows grouping when protected and also puts the user into design mode:

Please Login or Register  to view this content.

End Sub

I need to have this spreadsheet open on a specific worksheet, and was going to use this code:

Please Login or Register  to view this content.

Not sure if its the best way to do it and I don't know where to begin merging the two codes together (newbie ).

Thanks,
Joe

[mudraker]

Assuming you want YourSheetName to be the active sheet after the rest of the code has run then place the code before the End Sub command

[pike]

Please Login or Register  to view this content.

no thats about it

[tuckjoseph]

Thanks for your help! I can't seem to get it to work. I'm using:

Please Login or Register  to view this content.

What am I doing wrong?!

Thanks again,
Joe

[shg]

Once you go to design mode, VBA is done -- so you need to do that last.

Please Login or Register  to view this content.

[tuckjoseph]

Thanks a bundle, that works most awesomely!!!