Hi ALl!

I have a worksheet where I had created custom view to hide certain rows and
columns which user would not use very often, to make the worksheet a bit
easier to read. These custom views have worked fine until today.

My client asked if COmmand Buttons could be placed on the sheet for folks
who were "menu" challenged". This did not seem like a big issue. So I
created a command button object on the screen for each view, recorded a macro
to trigger each view, then added the macro code to the VB editor page for
each button. This worked just fine for a bit, and then the commands started
not working. No error messages, just when I would push the button for a
different view, nothing would happen. So I deleted the buttons, macros, and
any associated VB code in the editor and went back to just having the views
accessible from the menu. They still will not work. Also, I started getting
the Macro security wondow error when i would try to exit the Edit mode on the
Command toolbar.

I have verified there are no macros in the macro list
No Command object on the screen
Command toolbar closed
All Customs views are deleted
Saved and closed the workbook
Rebooted

Still, after I create a custom view, save it and close the custom view
dialog box, then I go back the worksheet and unhide all the rows and
columns...when I click on the custom view I just created in the dialog box
and click on "Show", nothing happens.

It is very bizarre, as everything worked fine this morning.
--
Greg

I don't know why you're having trouble with the views on this sheet, but I'd
start a fresh sheet and go step by step from there.

And, as far as your accessing the different views within the sheet, XL has
built in features that do just about what you're looking for.

This old post should give you some ideas on what can be done:

http://tinyurl.com/2rnogq


--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Greg in CO" <(E-Mail Removed)> wrote in message
news:88770359-C2CC-4275-B4D7-(E-Mail Removed)...
> Hi ALl!
>
> I have a worksheet where I had created custom view to hide certain rows
> and
> columns which user would not use very often, to make the worksheet a bit
> easier to read. These custom views have worked fine until today.
>
> My client asked if COmmand Buttons could be placed on the sheet for folks
> who were "menu" challenged". This did not seem like a big issue. So I
> created a command button object on the screen for each view, recorded a
> macro
> to trigger each view, then added the macro code to the VB editor page for
> each button. This worked just fine for a bit, and then the commands
> started
> not working. No error messages, just when I would push the button for a
> different view, nothing would happen. So I deleted the buttons, macros,
> and
> any associated VB code in the editor and went back to just having the
> views
> accessible from the menu. They still will not work. Also, I started
> getting
> the Macro security wondow error when i would try to exit the Edit mode on
> the
> Command toolbar.
>
> I have verified there are no macros in the macro list
> No Command object on the screen
> Command toolbar closed
> All Customs views are deleted
> Saved and closed the workbook
> Rebooted
>
> Still, after I create a custom view, save it and close the custom view
> dialog box, then I go back the worksheet and unhide all the rows and
> columns...when I click on the custom view I just created in the dialog box
> and click on "Show", nothing happens.
>
> It is very bizarre, as everything worked fine this morning.
> --
> Greg

Thanks! I'll give that shot!
--
Greg


"RagDyer" wrote:

> I don't know why you're having trouble with the views on this sheet, but I'd
> start a fresh sheet and go step by step from there.
>
> And, as far as your accessing the different views within the sheet, XL has
> built in features that do just about what you're looking for.
>
> This old post should give you some ideas on what can be done:
>
> http://tinyurl.com/2rnogq
>
>
> --
> HTH,
>
> RD
>
> ---------------------------------------------------------------------------
> Please keep all correspondence within the NewsGroup, so all may benefit !
> ---------------------------------------------------------------------------
>
> "Greg in CO" <(E-Mail Removed)> wrote in message
> news:88770359-C2CC-4275-B4D7-(E-Mail Removed)...
> > Hi ALl!
> >
> > I have a worksheet where I had created custom view to hide certain rows
> > and
> > columns which user would not use very often, to make the worksheet a bit
> > easier to read. These custom views have worked fine until today.
> >
> > My client asked if COmmand Buttons could be placed on the sheet for folks
> > who were "menu" challenged". This did not seem like a big issue. So I
> > created a command button object on the screen for each view, recorded a
> > macro
> > to trigger each view, then added the macro code to the VB editor page for
> > each button. This worked just fine for a bit, and then the commands
> > started
> > not working. No error messages, just when I would push the button for a
> > different view, nothing would happen. So I deleted the buttons, macros,
> > and
> > any associated VB code in the editor and went back to just having the
> > views
> > accessible from the menu. They still will not work. Also, I started
> > getting
> > the Macro security wondow error when i would try to exit the Edit mode on
> > the
> > Command toolbar.
> >
> > I have verified there are no macros in the macro list
> > No Command object on the screen
> > Command toolbar closed
> > All Customs views are deleted
> > Saved and closed the workbook
> > Rebooted
> >
> > Still, after I create a custom view, save it and close the custom view
> > dialog box, then I go back the worksheet and unhide all the rows and
> > columns...when I click on the custom view I just created in the dialog box
> > and click on "Show", nothing happens.
> >
> > It is very bizarre, as everything worked fine this morning.
> > --
> > Greg
>
>
>