Using of Customized Tool Bar in another file

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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...
 
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
 
Back
Top