Using of Customized Tool Bar in another file

P

PSL

Can we use the Customized Tool Bar in another file.

Example:

If I created a Tool Bar with Name: "PSL" While using from Tools Menu with
Customized Option.

Can I use the above Tool Bar "PSL" in another file.


Please do the needful on the above case.

Narayan PSL
 
D

Dave Peterson

What happened when you tried it?
Can we use the Customized Tool Bar in another file.

Example:

If I created a Tool Bar with Name: "PSL" While using from Tools Menu with
Customized Option.

Can I use the above Tool Bar "PSL" in another file.

Please do the needful on the above case.

Narayan PSL
Click to expand...
 
T

T. Valko

You need to create a 2 column table that lists the code number and the
corresponding item name:

................F.............G
1.........Code........Item
2..........123..........Pen
3..........124..........Paper
4..........125..........Book
5..........126..........Chair

Then, use this formula in B1:

=IF(A1="","",VLOOKUP(A1,F$2:G$5,2,0))

Copy down as needed.

Biff
 
Top