Interesting. Jump to vba project and find string Workbook_WindowActivate or
Workbook_WindowDeactivate or Workbook_WindowResize or
Workbook_WindowActivate picking CurrentProject I think there must be event
procedure.
Or Just as Vabz wrote create new workbook and if hiding sheets will occur
with
Create new excel file with 3-5 sheets & do same switching which you
mentioned in your email...
If this happens then you must have save above macro in personal.xlsb file
which will be working on all workbook rather on specific workbook.
cheers!!
On Wed, Mar 4, 2015 at 1:03 PM, Yahya Muhammad wro
Dear Maciej
Sheets in Workbook2 does not go hidden while opening. It happens all of a
sudden when I switch between these two workbooks. Just to add that I have a
userform in workbook1.
On Wed, Mar 4, 2015 at 9:47 AM, Maciej Piotrowicz
wrote:
> Hello
>
> For me one fitting answer is that on work
Hello
For me one fitting answer is that on workbook2 is the same event procedure
as above. It is not possible that event procedure from one workbook
influences another. Check macros in workbook2. Does all of workbooks go
hidden when opening?
Regards
W dniu poniedziałek, 2 marca 2015 09:25:24
