Using of Customized Tool Bar in another file

[Guest]

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

 

[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

 

[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