Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by keywordmonkey

  1. keywordmonkey

    Rolling out the same personal workbook to a team

    Hi I need to rollout the same personal macro workbook to a number of users. My current approach is to have each user run an install programme once that extracts the file to the diretory it needs to be in: C:\Documents and Settings\USERNAME\Application Data\Microsoft\Excel\XLSTART They can...
  2. keywordmonkey

    Problems with Excel macros on multiple machines

    The code looks at the contents of columns A - E on sheet1 and compares them to a set of rules (ma character length, does B contain http: or https: etc) defined in the macro. If they don't meet these conditions, the offending row should be moved to sheet2 and a message stating the problem placed...
  3. keywordmonkey

    Problems with Excel macros on multiple machines

    I can't actually post the code because (owned by my employer etc) However I've just found the smae problem with another macro, this time across 2 PCs. So it's got to be something more than just one set of code.
  4. keywordmonkey

    Problems with Excel macros on multiple machines

    Hopefully somebody has come across this problem deploying macros on multiple PCs. I've got a macro that runs fine on a colleague's PC. But on mine (same OS, same Excel version and service pack) it runs differently - namely it doesn't paste some data from sheet1 to sheet2. I suspect there is a...
  5. keywordmonkey

    Permanetly building macros into Excel

    Hi I need to build a number of macros into Excel permanently for a number of users to use for any spreadsheet, so they can access them via a button on the toolbar and/or menu item. However, I need to do this without storing the macros in spreadsheet if possible. So is there a way to build...
  6. keywordmonkey

    Public holidays dates add in for Outlook

    Unfortuantley the holidays data with Outlook (2k version at least) is out of date - update is here http://microsoft.com/downloads/details.aspx?FamilyID=7d4d9017-8d4e-4963-8ba7-d2e91d491f5e&DisplayLang=en Close Outllok, install it, then do the steps described in above post. More info on this...
  7. keywordmonkey

    Public holidays dates add in for Outlook

    Thanks. The one place I didn't look was Outlook itself. D'oh!
  8. keywordmonkey

    Public holidays dates add in for Outlook

    Hi All Has anybody come across a free/low cost add-in which automatically updates the Outlook calendar with official public holidays? I need this for the US, and major EU countries. I couldn't find one on microsoft.com, but I may have missed it...
  9. keywordmonkey

    Filling down for as long as cells in another column are full

    Thanks everyone for the help . In this case the code was the most useful as I need to add it into a macro I hava managed to record and edit myself - this part was the stumbling block (I should have said). Ref. commenting code, it certainly does help me learn; I've been commenting every...
  10. keywordmonkey

    Filling down for as long as cells in another column are full

    Hi I've been trying to write code that will fill down a formula in F1. It needs to fill down for the same number of cells that have values in Column C. So if there were values in C1-C256, the formula would automatically fill down in F1-F256. I know it needs an IF argument but I don't have...
  11. keywordmonkey

    Excel: Removing spaces at the start and / or end of text in cells

    Cheers all for this - hope to do a FAQ one day on manipulating text in Excel. Will include this & post to the site.
  12. keywordmonkey

    Excel: Removing spaces at the start and / or end of text in cells

    Hi I've got lots of sheets with text in cell A that has spaces at the start/end/both, of the text. Currently I can remove this by pasting into Word, justifying into the centre, to the right and then to the left (the only clumsy solution I've found). I'd like to either use a macro to do this...
  13. keywordmonkey

    Removing multiple HTML links across rows

    A couple of days have passed, I've learnt some code and can answer my own question. The below code runs across the active sheet on all cells. Sub RemoveLiveLinks () ' This macro removes any hyperlinks, so they become normal text and when clicked don't open a webpage ' It runs on every cell...
  14. keywordmonkey

    Excel: changing text colour when a character length is exceeded

    Excellent - worked first time. Cheers.
  15. keywordmonkey

    Excel: changing text colour when a character length is exceeded

    I want to be able to automatically change the text colour to red if the user types more than a set number of characters (including spaces). So if I set the limit was 75 for D1, I'd want the text to go red if they typed 80. I've seen this done, I think without a macro, and can't find any data...
See more

Part and Inventory Search

Back
Top