Hide a workbook before saving
 

I have given the user a menu option to set the ISADDIN property of my addin
to false. When they choose the option they are able to make changes to a
parameter sheet. I want to ensure that the the workbook is still saved as an
addin, so I have set ISADDIN back to true in the beforesave event. For some
reason though, excel doesn't always do what I want it to do: The beforesave
event is triggered, and the property gets changed, but then instead of saving
the addin, excel saves the active workbook, which, due to the fact that it's
just been hidden, can't be the addin. In the case where the addin is the
only open workbook, it gets saved as I want it to.

any advice??

Thanks
Rob

Hide a workbook before saving
 

Use

ThisWorkbook.Save

rather than
Activeworkbook.Save

--
Regards,
Tom Ogilvy

"Rob" wrote in message
...
I have given the user a menu option to set the ISADDIN property of my
addin
to false. When they choose the option they are able to make changes to a
parameter sheet. I want to ensure that the the workbook is still saved as
an
addin, so I have set ISADDIN back to true in the beforesave event. For
some
reason though, excel doesn't always do what I want it to do: The
beforesave
event is triggered, and the property gets changed, but then instead of
saving
the addin, excel saves the active workbook, which, due to the fact that
it's
just been hidden, can't be the addin. In the case where the addin is the
only open workbook, it gets saved as I want it to.

any advice??

Thanks
Rob

Hide a workbook before saving
 

sorry, should have posted my code. I DID use thisworkbook.save.
Rob

"Tom Ogilvy" wrote:

Use

ThisWorkbook.Save

rather than
Activeworkbook.Save

--
Regards,
Tom Ogilvy

"Rob" wrote in message
...
I have given the user a menu option to set the ISADDIN property of my
addin
to false. When they choose the option they are able to make changes to a
parameter sheet. I want to ensure that the the workbook is still saved as
an
addin, so I have set ISADDIN back to true in the beforesave event. For
some
reason though, excel doesn't always do what I want it to do: The
beforesave
event is triggered, and the property gets changed, but then instead of
saving
the addin, excel saves the active workbook, which, due to the fact that
it's
just been hidden, can't be the addin. In the case where the addin is the
only open workbook, it gets saved as I want it to.

any advice??

Thanks
Rob