Thanks, I tried recording the macro and it wasn't working and it's Monday so
I gave up too early. I was naming pointing the button code to a blank macro.


The workbook is passed from one person to another with additional info added
each time. So, I want the buttons to appear when they open the workbook and
I think I got that figured out but now if they resize a column it screws up
the button. Is there some setting I'm missing?

"Tom Ogilvy" wrote:

You can get the code to set the view by turning on the macro recorder and
changing the view manually.

Then the question is what you want the user to do to change the view. You
can put buttons on the worksheet using the forms toolbar - then you would
assign a macro to the button and change the caption. Or you could put
commandbuttons from the control toolbox toolbar and by double clicking on
them in design mode, access the click event code where you would put in the
commands you recorded.

I don't see a role for the Thisworkbook module unless you want to use the
Workbook_Open event to initialize the view or perform some other initializing
action.

--
Regards,
Tom Ogilvy


"RominallL" wrote:

I have several custom views set up in a workbook and would like to make them
into buttons for those users who simply don't like using the menu bar. I've
done it before but that was a long time ago and my memory just isn't what it
used to be. I vaguely recall having to set something up in the "THis
workbook" module.