Bizarre Custom Views behavior

G

Greg in CO

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.
 
R

RagDyer

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
 
G

Greg in CO

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


RagDyer said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top