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

Need Help with Macro Security 1
Excel does not accept text format! 0
Easiest way to add functionality to ALL Excel spreadsheets 5
What is brest way to flit between two spreadsheets 1
Is there a way to turn events on or off? 1
Can I edit macro buttons on the quick access toolbar in excel? 0
Responding to cell events in Excel 1
The instruction at "0x65255ac9" referenced memory at "0x00000008". The memory could not be read. C 1

Top