Editing worksheets in a .xlam file

Yes, it is possible.

1. Make sure project explorer and properties windows are both visible in VBA
2. Select thisworkbook from project explorer, and set IsAddin property to false.

This will make worksheets visible. Make your changes to the worksheets and reset the isaddin property to true.