I want the user to see the sheets in an addin, so

is there a way to set the IsAddin property to False from a toolbar etc. so
the sheets in the addin can be visible. Basically I want the user to be able
to edits data on the sheets of the addin.

....and then set IsAddin back \to true to hide the sheets?

Thanks

I will credit any helpful responses

Then why not just make it a standard workbook. Problem solved!

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"DZ" <(E-Mail Removed)> wrote in message
news:1F4C5A9A-1572-4327-8889-(E-Mail Removed)...
>I want the user to see the sheets in an addin, so
>
> is there a way to set the IsAddin property to False from a toolbar etc. so
> the sheets in the addin can be visible. Basically I want the user to be
> able
> to edits data on the sheets of the addin.
>
> ...and then set IsAddin back \to true to hide the sheets?
>
> Thanks
>
> I will credit any helpful responses
>
>

Workbooks("personal.xla").IsAddin = False 'True

Have you ever used Data|Form (xl2003 menus)?

If you have, you may want to try displaying that to allow edits to your sheet.

With Workbooks("youraddinhere.xla").Worksheets("sheetnamehere")
.ShowDataForm
End With

Some more info:
http://support.microsoft.com/default...;en-us;q110462
XL: ShowDataForm Method Fails If Data Can't Be Found



DZ wrote:
>
> I want the user to see the sheets in an addin, so
>
> is there a way to set the IsAddin property to False from a toolbar etc. so
> the sheets in the addin can be visible. Basically I want the user to be able
> to edits data on the sheets of the addin.
>
> ...and then set IsAddin back \to true to hide the sheets?
>
> Thanks
>
> I will credit any helpful responses

--

Dave Peterson