Thread: Excel or Access
View Single Post
  #16  
Old January 23rd, 2008, 10:46 PM posted to microsoft.public.excel.setup
Gord Dibben
external usenet poster
 
Posts: 20,252
Default Custom Views (was: Excel or Access)

Adding buttons to your Toolbar does not give users access to those buttons on
their computer or account.

You can create a Toolbar with the buttons by code in the workbook.

OR you could create a Toolbar through ToolsCustomizeToolbarsNew.

Add a couple of buttons to that toolbar then Attach it to the workbook via
ToolsCustomizeToolbarsAttach.

The safest and best method is on the fly code in the workbook to create then
delete when the workbook is closed.

For sample code and a downloadable workbook see Debra's site.

http://www.contextures.on.ca/xlToolbar02.html


Gord Dibben MS Excel MVP

On Wed, 23 Jan 2008 13:37:02 -0800, Jo4321
wrote:

I'm back with more questions.

I set up my spreadsheet with the custom views and the form entry and put
those two things on my toolbar. When others pull up the spreadsheet on the
network, they do not have the things I added to the toolbar. Do I have to go
to each computer and set up each persons toolbar to show the form and custom
view buttons?

Thanks,
Jo