View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Ed[_31_] Ed[_31_] is offline
external usenet poster
 
Posts: 34
Default Axcessing worksheets in an add-in

Thanks, Tim. All is well now.

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