Can I set a spreadsheet so that when it is opened, a particular toolbar is loaded.

A

Angus Comber

Hello

I have created a toolbar in Excel which works fine. However, it seems to be
'global' to all Excel spreadsheets. I want it to only appear if a certain
spreadsheet is opened. How do I do that?

Angus Comber
(e-mail address removed)
 
B

BrianB

1.Activate the worksheet.
2.Right click a toolbar to get the Customize option.
3.Toolbars tab
4.Select the toolbar.
5.Click on the Attach button.
6.Save the workbook.
7.Repeat 1 to 3 and uncheck the toolbar so it is not global any more.


Regards
BrianB
=======================================
 

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

Similar Threads

What is brest way to flit between two spreadsheets 1
Easiest way to add functionality to ALL Excel spreadsheets 5
The instruction at "0x65255ac9" referenced memory at "0x00000008". The memory could not be read. C 1
Use macro code from external xls file 1
Can I prevent users selecting multiple cells? 4
How do I install XP on a 160GB IDE drive 4
Is there a Win XP Home to Professional upgrade? 1
toolbar macro on template 11

Top