Pages

Search

Excel Help Forum - Excel General: Show the images based on the selective cell value

Feed2Mail notification - new post on Excel Help Forum - Excel General
Show the images based on the selective cell value
Dear experts, I have Equipment list with photos in sheet 1, In "HK-Cl Machineries" sheet when I select B column cell the image should shows in top of the black shaded area.Pls provide the code for this thread.For your reference pls find the attached sample sheet..

Excel IT Pro Discussions Forum: Cannot delete excel 2010 It is being used by another person or program

Feed2Mail notification - new post on Excel IT Pro Discussions Forum
Cannot delete excel 2010 It is being used by another person or program

Cannot delete excel 2010  It is being used by another person or program

This is an issue for 2010 shared Excel files, they either open as Read-only or "locking the file" when user not actually within the files but this has only been an issue for her since the upgrade to office 2010.

1)I have cleared temp files and tested but this is still an issue
2)My computer>manage>open files >there is no open files from user and no sessions from user.

3)Please note share drive is on SAN not on file server or locally. If we copy the file from share drive to terminal server it works fine

4)in share drive we cannot rename the file and cannot rename the extinctions like .xls xlsx,xlsm etc..

5)Tried to repair the excel no luck to resolve ,workaround advised saveas the file ,There is no proper Microsoft articles to resolve this issue .please let me know if any

Excel Help Forum - Excel Programming / VBA / Macros: Excel ask every time for outlook profile

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Excel ask every time for outlook profile
Every time i start this code, Outlook is asking for a profile. what do i wrong? if i start outlook first, then there are no questions, but a'm not be able to start everytime outlook first, so this code has to find the profile by itself.. Code: Application.ScreenUpdating = True Dim OutApp As...

Excel Help Forum - Excel General: I can't run macro when I protect the worksheet

Feed2Mail notification - new post on Excel Help Forum - Excel General
I can't run macro when I protect the worksheet
I am sorry if my English is poor. I unlocked cells in the area that macro will use for calculation. When I protect the worksheet the macro could not run. But when I unprotect the worksheet the macro can run again. I want to know how to protect some cells in the worksheet and also enable the...

Excel Help Forum - Excel General: Summing and Averageing, based on criteria.

Feed2Mail notification - new post on Excel Help Forum - Excel General
Summing and Averageing, based on criteria.
Hi All, I currently have an excel table with staff members names (which wont change) and I'm seeking a way to work out the average time it takes them to complete a project. Attachment 188957 (http://www.excelforum.com/attachment.php?attachmentid=188957) In this example John and Mike both...

Excel Help Forum - Excel Programming / VBA / Macros: Web Query Help? - Query Picture Title or Alt Text on a webpage?

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Web Query Help? - Query Picture Title or Alt Text on a webpage?
Hey, I am querying a few things from a webpage with getElementsByClassName right now and it is working well. However I want to be able to get the picture title or alt text from html? It may just be changing the options with getElementsByClassName, but I am not sure how. Here is an example...

Excel Help Forum - Excel General: Sort on cells with all caps

Feed2Mail notification - new post on Excel Help Forum - Excel General
Sort on cells with all caps
There is a solution here, which prioritizes capitals http://www.excelforum.com/excel-general/699248-case-sensitive-sorting-all-caps-first-then-all-lowercase.html But what I want is to have first cells where all letters are capitals, and then cells with lowercase or mixed case in a way that it...
Subscribe to: Comments (Atom)