Ok, I found it. Pls disregard last note.

Thanks!

Ed


"Tim Williams" <timjwilliams at gmail dot com wrote in message
...
In the VBE set the "IsAddin" property of the xla to False: that will
expose the worksheets and allow you to edit them. Set back to True
when done.

Tim


"Ed" wrote in message
...
Back in May I got some help here in separating my VBA code from the
.xls file to be exposed to the user.
It works fine now. When the user opens the .xls file the .xla gets
loaded and the subroutine that installs
a command menu runs.

The question now is how do I maintain some things that are in
worksheets that I chose to leave in
the .xls file? Let me be more specific. I have certain parameters
in a worksheet in the .xla file. These things
are read and used in the macros. I had hoped to have easy access to
them just by clicking on the worksheet
object in the VBA Project tree for the xla file, then changing
cells in the normal Excel manner.

The problem is the VBA editor will only allow be to view and work
with the code, not the object.
I imagine I could edit what's in this worksheet via code, but that
seems awkward.

Is there any way around this?

TIA

Ed