Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking pictures/logo in excel
I have developed a number of spreadsheets in Excel 2003 that I will be
sharing with schools. I want each school to be able to insert their own school logo so that it appears on each sheet. I have a menu page and was looking for a way to insert a logo on that page and then paste link it or some similar method. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking pictures/logo in excel
Good afternoon. It you find something you can use on Mr. McGimpsey's site:
http://www.mcgimpsey.com/excel/lookuppics.html. Good luck. -- Sincerely, Michael Colvin "smallschoolie" wrote: I have developed a number of spreadsheets in Excel 2003 that I will be sharing with schools. I want each school to be able to insert their own school logo so that it appears on each sheet. I have a menu page and was looking for a way to insert a logo on that page and then paste link it or some similar method. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking pictures/logo in excel
Michael
Thanks for the info - no luck with my problem but a useful reference page anyway. Paul "Michael" wrote: Good afternoon. It you find something you can use on Mr. McGimpsey's site: http://www.mcgimpsey.com/excel/lookuppics.html. Good luck. -- Sincerely, Michael Colvin "smallschoolie" wrote: I have developed a number of spreadsheets in Excel 2003 that I will be sharing with schools. I want each school to be able to insert their own school logo so that it appears on each sheet. I have a menu page and was looking for a way to insert a logo on that page and then paste link it or some similar method. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking pictures/logo in excel
Sorry about that. Good luck with your project and Merry Christmas.
-- Sincerely, Michael Colvin "smallschoolie" wrote: Michael Thanks for the info - no luck with my problem but a useful reference page anyway. Paul "Michael" wrote: Good afternoon. It you find something you can use on Mr. McGimpsey's site: http://www.mcgimpsey.com/excel/lookuppics.html. Good luck. -- Sincerely, Michael Colvin "smallschoolie" wrote: I have developed a number of spreadsheets in Excel 2003 that I will be sharing with schools. I want each school to be able to insert their own school logo so that it appears on each sheet. I have a menu page and was looking for a way to insert a logo on that page and then paste link it or some similar method. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking pictures/logo in excel
Maybe you could put all the logos on a separate worksheet. Then hide that
sheet. Give the user a macro that would allow them to copy their logo to each of the worksheets in that workbook. I created a worksheet named Pictures. I dropped a few pictures in that sheet, then hid that sheet. I created a worksheet named Index and added a combobox and a commandbutton (both from the control toolbox toolbar). I rightclicked on the Index worksheet tab and selected view code and pasted this in: Option Explicit Dim blkProc As Boolean Private Sub ComboBox1_Change() Dim mySheetNames As Variant Dim myPict As Picture Dim wks As Worksheet Dim myAddr As String Dim LogoName As String If blkProc = True Then Exit Sub If Me.ComboBox1.ListIndex = -1 Then Exit Sub mySheetNames = Array("Sheet2", "sheet3", "sheet5") myAddr = "A1:B3" LogoName = "SchoolLogo" Set myPict = Nothing On Error Resume Next Set myPict = Me.Parent.Worksheets("Pictures") _ .Pictures(Me.ComboBox1.Value) On Error GoTo 0 If myPict Is Nothing Then MsgBox "Please refresh and try again." & vbLf & _ "Contact xxxx at #### if it fails a second time!" Exit Sub End If Application.ScreenUpdating = False For Each wks In Me.Parent.Worksheets(mySheetNames) On Error Resume Next wks.Pictures(LogoName).Delete On Error GoTo 0 myPict.Copy wks.Paste wks.Select ActiveCell.Activate Set myPict = wks.Pictures(wks.Pictures.Count) 'the one just added With wks.Range(myAddr) myPict.Top = .Top myPict.Width = .Width myPict.Height = .Height myPict.Left = .Left End With myPict.Name = LogoName Next wks Me.Select End Sub Private Sub CommandButton1_Click() Dim myPict As Picture With Me.ComboBox1 blkProc = True .Clear blkProc = False For Each myPict In Me.Parent.Worksheets("Pictures").Pictures .AddItem myPict.Name Next myPict End With End Sub Change this: Array("Sheet2", "sheet3", "sheet5") to the sheetnames that should get the logo. smallschoolie wrote: I have developed a number of spreadsheets in Excel 2003 that I will be sharing with schools. I want each school to be able to insert their own school logo so that it appears on each sheet. I have a menu page and was looking for a way to insert a logo on that page and then paste link it or some similar method. -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking pictures/logo in excel
Dave
Thanks for the ideas it helped me work through the problem. Have a great new year. Regards Paul "smallschoolie" wrote: I have developed a number of spreadsheets in Excel 2003 that I will be sharing with schools. I want each school to be able to insert their own school logo so that it appears on each sheet. I have a menu page and was looking for a way to insert a logo on that page and then paste link it or some similar method. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking pictures/logo in excel
Glad it worked for you.
smallschoolie wrote: Dave Thanks for the ideas it helped me work through the problem. Have a great new year. Regards Paul "smallschoolie" wrote: I have developed a number of spreadsheets in Excel 2003 that I will be sharing with schools. I want each school to be able to insert their own school logo so that it appears on each sheet. I have a menu page and was looking for a way to insert a logo on that page and then paste link it or some similar method. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Linking feature changed in Excel? | Excel Discussion (Misc queries) | |||
Linking Excel to Outlook?? | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
linking an excel document to my task folder in outlook | Excel Discussion (Misc queries) |