Hidden Tabs appear when I reopen the file

Did you see the code i posted before your response? Any clue with all of
those codes i didn't enter those they were there when i got this program
should i enter the code you mentioned at the end of what i pasted below.
--
Thank you, Brenda


"Dave Peterson" wrote:

> When I hide the tabs in xl2003 and save the workbook with that window's tabs
> hidden, then the tabs are hidden when I reopen the workbook.
>
> I don't have a guess why they're shown for you.
>
> But maybe you could add a line in your workbook_open procedure to hide the tabs:
>
> Me.DisplayWorkbookTabs = False
>
> (Me refers to the object that owns the code--in this case, it's the workbook
> itself.)
>
>
>
> Brenda wrote:
> >
> > I am working in Excel 2003. I am not the designer of the program and there
> > are a lot of formulas, links etc in this program. However, i have placed
> > buttons from the forms toolbar and hide the tabs located at the bottom. In
> > otherwords they click on the bottom and it brings up the tab i hide and on
> > that page another button that says take back to the home page and hides that
> > tab again. My problem is when i close out the program and go back in the tabs
> > are back at the bottom and i have to hide them to make the buttons work. How
> > can i get them to stay hidden when the program is opened.
> > --
> > Thank you, Brenda
>
> --
>
> Dave Peterson
>

I saw the code and didn't notice anything in there that would change the
visibility of the tabs.

But there were lots of calls to a couple of macros that may do something that
you didn't share.

Try looking through those procedures to see if you have any
"DisplayWorkbookTabs" in them.

Heck, maybe searching the entire workbook's project for that would be
worthwhile.

=====
But if you want to take the easy route (I would!)...

Just try:

....
loadWorkbook
Me.DisplayWorkbookTabs = False
End Sub

But I don't know what LoadWorkbook does. Maybe that line of code really belongs
in that procedure????



Brenda wrote:
>
> Did you see the code i posted before your response? Any clue with all of
> those codes i didn't enter those they were there when i got this program
> should i enter the code you mentioned at the end of what i pasted below.
> --
> Thank you, Brenda
>
> "Dave Peterson" wrote:
>
> > When I hide the tabs in xl2003 and save the workbook with that window's tabs
> > hidden, then the tabs are hidden when I reopen the workbook.
> >
> > I don't have a guess why they're shown for you.
> >
> > But maybe you could add a line in your workbook_open procedure to hide the tabs:
> >
> > Me.DisplayWorkbookTabs = False
> >
> > (Me refers to the object that owns the code--in this case, it's the workbook
> > itself.)
> >
> >
> >
> > Brenda wrote:
> > >
> > > I am working in Excel 2003. I am not the designer of the program and there
> > > are a lot of formulas, links etc in this program. However, i have placed
> > > buttons from the forms toolbar and hide the tabs located at the bottom. In
> > > otherwords they click on the bottom and it brings up the tab i hide and on
> > > that page another button that says take back to the home page and hides that
> > > tab again. My problem is when i close out the program and go back in the tabs
> > > are back at the bottom and i have to hide them to make the buttons work. How
> > > can i get them to stay hidden when the program is opened.
> > > --
> > > Thank you, Brenda
> >
> > --
> >
> > Dave Peterson
> >

--

Dave Peterson

how would i bring up the entire worksheet projects?
--
Thank you, Brenda


"Dave Peterson" wrote:

> I saw the code and didn't notice anything in there that would change the
> visibility of the tabs.
>
> But there were lots of calls to a couple of macros that may do something that
> you didn't share.
>
> Try looking through those procedures to see if you have any
> "DisplayWorkbookTabs" in them.
>
> Heck, maybe searching the entire workbook's project for that would be
> worthwhile.
>
> =====
> But if you want to take the easy route (I would!)...
>
> Just try:
>
> ....
> loadWorkbook
> Me.DisplayWorkbookTabs = False
> End Sub
>
> But I don't know what LoadWorkbook does. Maybe that line of code really belongs
> in that procedure????
>
>
>
> Brenda wrote:
> >
> > Did you see the code i posted before your response? Any clue with all of
> > those codes i didn't enter those they were there when i got this program
> > should i enter the code you mentioned at the end of what i pasted below.
> > --
> > Thank you, Brenda
> >
> > "Dave Peterson" wrote:
> >
> > > When I hide the tabs in xl2003 and save the workbook with that window's tabs
> > > hidden, then the tabs are hidden when I reopen the workbook.
> > >
> > > I don't have a guess why they're shown for you.
> > >
> > > But maybe you could add a line in your workbook_open procedure to hide the tabs:
> > >
> > > Me.DisplayWorkbookTabs = False
> > >
> > > (Me refers to the object that owns the code--in this case, it's the workbook
> > > itself.)
> > >
> > >
> > >
> > > Brenda wrote:
> > > >
> > > > I am working in Excel 2003. I am not the designer of the program and there
> > > > are a lot of formulas, links etc in this program. However, i have placed
> > > > buttons from the forms toolbar and hide the tabs located at the bottom. In
> > > > otherwords they click on the bottom and it brings up the tab i hide and on
> > > > that page another button that says take back to the home page and hides that
> > > > tab again. My problem is when i close out the program and go back in the tabs
> > > > are back at the bottom and i have to hide them to make the buttons work. How
> > > > can i get them to stay hidden when the program is opened.
> > > > --
> > > > Thank you, Brenda
> > >
> > > --
> > >
> > > Dave Peterson
> > >
>
> --
>
> Dave Peterson
>

Dave sorry to be a pain your suggestion worked. however when i went onto
other worksheets in the same document and clicked on the buttons they gave me
an error
compile error in hidden module when it first brings up the file i get the
same error any suggestions?
--
Thank you, Brenda


"Dave Peterson" wrote:

> I saw the code and didn't notice anything in there that would change the
> visibility of the tabs.
>
> But there were lots of calls to a couple of macros that may do something that
> you didn't share.
>
> Try looking through those procedures to see if you have any
> "DisplayWorkbookTabs" in them.
>
> Heck, maybe searching the entire workbook's project for that would be
> worthwhile.
>
> =====
> But if you want to take the easy route (I would!)...
>
> Just try:
>
> ....
> loadWorkbook
> Me.DisplayWorkbookTabs = False
> End Sub
>
> But I don't know what LoadWorkbook does. Maybe that line of code really belongs
> in that procedure????
>
>
>
> Brenda wrote:
> >
> > Did you see the code i posted before your response? Any clue with all of
> > those codes i didn't enter those they were there when i got this program
> > should i enter the code you mentioned at the end of what i pasted below.
> > --
> > Thank you, Brenda
> >
> > "Dave Peterson" wrote:
> >
> > > When I hide the tabs in xl2003 and save the workbook with that window's tabs
> > > hidden, then the tabs are hidden when I reopen the workbook.
> > >
> > > I don't have a guess why they're shown for you.
> > >
> > > But maybe you could add a line in your workbook_open procedure to hide the tabs:
> > >
> > > Me.DisplayWorkbookTabs = False
> > >
> > > (Me refers to the object that owns the code--in this case, it's the workbook
> > > itself.)
> > >
> > >
> > >
> > > Brenda wrote:
> > > >
> > > > I am working in Excel 2003. I am not the designer of the program and there
> > > > are a lot of formulas, links etc in this program. However, i have placed
> > > > buttons from the forms toolbar and hide the tabs located at the bottom. In
> > > > otherwords they click on the bottom and it brings up the tab i hide and on
> > > > that page another button that says take back to the home page and hides that
> > > > tab again. My problem is when i close out the program and go back in the tabs
> > > > are back at the bottom and i have to hide them to make the buttons work. How
> > > > can i get them to stay hidden when the program is opened.
> > > > --
> > > > Thank you, Brenda
> > >
> > > --
> > >
> > > Dave Peterson
> > >
>
> --
>
> Dave Peterson
>

Glad you got part of your problem fixed.

I'm not sure when you get the error.

Do you get it when you open the workbook with the change you just made?

If yes, then maybe you changed something that you shouldn't have.

If you're getting the error when you click on the button, then it's not this
changed that caused the trouble. If the tabs or hidden or shown, the code
would work (or blow up) the same way.

To help debug the problem, you're going to have to find the workbook that's
causing the trouble. Then unprotect that workbook's project (in the VBE). And
save that (as a new copy).

Then close and reopen that new workbook. The project won't be protected, so
you'll get an option to debug. And that should point at the line of code that
caused the trouble.

Then fix that workbook and test it out. If it works fine, you can save as the
old name -- or fix the real workbook's project.


Brenda wrote:
>
> Dave sorry to be a pain your suggestion worked. however when i went onto
> other worksheets in the same document and clicked on the buttons they gave me
> an error
> compile error in hidden module when it first brings up the file i get the
> same error any suggestions?
> --
> Thank you, Brenda
>
> "Dave Peterson" wrote:
>
> > I saw the code and didn't notice anything in there that would change the
> > visibility of the tabs.
> >
> > But there were lots of calls to a couple of macros that may do something that
> > you didn't share.
> >
> > Try looking through those procedures to see if you have any
> > "DisplayWorkbookTabs" in them.
> >
> > Heck, maybe searching the entire workbook's project for that would be
> > worthwhile.
> >
> > =====
> > But if you want to take the easy route (I would!)...
> >
> > Just try:
> >
> > ....
> > loadWorkbook
> > Me.DisplayWorkbookTabs = False
> > End Sub
> >
> > But I don't know what LoadWorkbook does. Maybe that line of code really belongs
> > in that procedure????
> >
> >
> >
> > Brenda wrote:
> > >
> > > Did you see the code i posted before your response? Any clue with all of
> > > those codes i didn't enter those they were there when i got this program
> > > should i enter the code you mentioned at the end of what i pasted below.
> > > --
> > > Thank you, Brenda
> > >
> > > "Dave Peterson" wrote:
> > >
> > > > When I hide the tabs in xl2003 and save the workbook with that window's tabs
> > > > hidden, then the tabs are hidden when I reopen the workbook.
> > > >
> > > > I don't have a guess why they're shown for you.
> > > >
> > > > But maybe you could add a line in your workbook_open procedure to hide the tabs:
> > > >
> > > > Me.DisplayWorkbookTabs = False
> > > >
> > > > (Me refers to the object that owns the code--in this case, it's the workbook
> > > > itself.)
> > > >
> > > >
> > > >
> > > > Brenda wrote:
> > > > >
> > > > > I am working in Excel 2003. I am not the designer of the program and there
> > > > > are a lot of formulas, links etc in this program. However, i have placed
> > > > > buttons from the forms toolbar and hide the tabs located at the bottom. In
> > > > > otherwords they click on the bottom and it brings up the tab i hide and on
> > > > > that page another button that says take back to the home page and hides that
> > > > > tab again. My problem is when i close out the program and go back in the tabs
> > > > > are back at the bottom and i have to hide them to make the buttons work. How
> > > > > can i get them to stay hidden when the program is opened.
> > > > > --
> > > > > Thank you, Brenda
> > > >
> > > > --
> > > >
> > > > Dave Peterson
> > > >
> >
> > --
> >
> > Dave Peterson
> >

--

Dave Peterson

Hi Brenda

Show the code you are using to do this, and somebody may be able to help.

--
Regards
Roger Govier

"Brenda" <Brenda DeleteThis @discussions.microsoft.com> wrote in message
news:337D2121-93AC-4401-B8EB-E5F47EB82777@microsoft.com...
> I am working in Excel 2003. I am not the designer of the program and there
> are a lot of formulas, links etc in this program. However, i have placed
> buttons from the forms toolbar and hide the tabs located at the bottom. In
> otherwords they click on the bottom and it brings up the tab i hide and on
> that page another button that says take back to the home page and hides
> that
> tab again. My problem is when i close out the program and go back in the
> tabs
> are back at the bottom and i have to hide them to make the buttons work.
> How
> can i get them to stay hidden when the program is opened.
> --
> Thank you, Brenda